DSXchange

Hi Im using a look up stage to look up against an oracle table (oracle stage- 1 million rows) i get the following warning message for all the columns. Can anybody help me get rid if this warning message. Warning Message: Lookup_143: When checking operator: Dropping component "CUSTOMERREFERENCEI...

What is the data type you are using there, is it decimal or double.

Somewhat. Any columns handled by RCP will be strictly "pass-through", i.e. with zero in the way of transformations. ... Thanks :) Hi i had worked in the same kind of situation. but mine was little different. we had a ods where all the transformations will be done and with this as a source...

Somewhat. Any columns handled by RCP will be strictly "pass-through", i.e. with zero in the way of transformations. ... Thanks :) Hi i had worked in the same kind of situation. but mine was little different. we had a ods where all the transformations will be done and with this as a source...

Hi

is there a seperate version of datastage that runs in unix, or the same software can run in both unix and windows?

Hi I would like to pass a parameter to my job from a unix command. the unix command reads a file that has one value (1000) and shoudl pass that as a parameter to the job. in the job properties window im using the before job subroutine, i use the following command cat path/file_name.txt #DsParameter#...

Hi DS: 7.5 DB: Oracle 10g Im running a sequence with three job activities, the 1st one is a job that creates a date (dd-mon-yyyy) and write it to a sequential file, the secont is a routine (2nd) that reads this date and passes this date to the next job (3rd) activity. the 3rd job reads data from a t...

as far as i know only the server job(transformer) has the before / after job subroutine, parallel job (transformer) dosent have it.... could u please tell me which stage are you looking at?

once u open the job press control+j and the job properties will pop up.. u have the before and after subroutine box there.. or check in the transformwe properties as said...

Yest thats right you can use an aggregator stage to get the row count.

use the following options:

in the aggregator stage:
aggregation type: CountRows.

this should work.

Hi Thank you so much for the suggestion, i really appreciate that. im sorry i was in a hurry thats why, I still have the warning message. but when i tested the same job by running from the designer it ran, but when i run the sequence from the DS director it aborts, so i removed the limits for the wa...

Hi DS 7.5.2 DB: oracle 10g I have a job that has a dataset as source, and several look ups and all of them are joined using a merge stage and then load it to a dataset. now if i run this job i get the following warning message and it says job aborted. warning message: APT_CombinedOperatorController(...

Hi I posted this question yesterday, and now i have some more questions about the same. Source : oracle Target : oracle I have primary key constraint and not null constraint in the target table. i have several hash lookups in the DS job. I already had some data in the target table, this data will be...

Thank you chulett for the explanation, I remember now, I was testing the job and for the first time i loaded the data and while testing it again i didnt truncate the tables. (i was testing witht he same data). I believe thats why it might have loaded the duplicates, also when i checked for the numbe...

Hi im loading into Oracle tables. Im using DS 7.5.2. The job design has a source text file, lookup hasfiles and a target odbc stage. While loading data into the table i got the following error: ORA-01502: index 'CAIODS.SYS_C0091669' or partition of such index is in unusable state so i checked with t...