DSXchange

Thanks Ray,
The version is 7.5 .still unable to edit derivation in the output of the lookupstage. .anyway I was also rethinking that approach..will try with the transformer and switch as suggested by you....
Ash.

Hi All, In a process flow we were using a server job for doing a lookup to a hash file to lookup the value of a field and in the output we were writing the derivation for a column as: If Field1 is 0 thenlookup.field1+@outrownum else mainstream.field1 . The output was going to oracle. The main stream...

A constraint is basically a restriction placed upon the data values that can be stored in a column or columns of a table. Check the specific constraint for the particular table you are dealing with....
Ash.

Hi,
Did you try enabling or disabling the row buffer?

check what you have installed.........

Hi rajeev, 9 represents numeric ...and thats it...... if there no comp clause to it , as kumar has already metioned the data may containalphanumerics..and if you have checked the data then it is impossible that picture 9 can represent a character....... The only thing that can come in between pic 9 ...

Sorry Kim,
Never tried it...so was unable to recognise the tradeoff between (400*few minutes) Vs Stage type switching in a DSX...my bad.
Thanks.

Small fish ..big mouth..sorry
Kim's approach though simple would require coding for all 400 files that Arnd is getting...right?
Ash.

Hello Fernando, A good point to start will be looking into the source file which you will be getting. If it is a cobol file then identify the metadata with the help of .cfd. Once you understand the fields in the source field and define the metadata accordingly in datsatage then you will be good to g...

Hi ray,
Thankx.I overlooked this point. Many other users were also accessing oracle posibbly same table..some other process running at the same time may have caused the undo tablespace to be depleted.
Thank You.

Hi all, I am reading from oracle tables using odbc. I am using a user defined sql to pull records from source tables. Target is oracle and i am using odbc to write to target table. I have specified transaction size as 100 and array size as 1 in target stage and transaction handling as none for sourc...

Hi, My apologies for posting this topic in the wrong forum. No. There is no transformation being applied to the date. The date did not become 2003 during transformation..rather it was selected from the source inspite of there being a where clause. On rerun the 2003 date was not selected..nor is it b...

Hi, When I executed the job once again it didnt generate the error. Anyway,I am just going to remove the job from the sequence to be on safer side. Since the number of records is not much and I am using this job to create a lookup for the next job,i guess i will eliminate this job .Performance is no...

no it doesnt ...

Oracle using DRS.
....and intrestingly the job does not generate any warning if i run it stand alone.
Thanks.