DSXchange

Hi, while using Remove duplicates stage I get this warning. "Remove_Duplicates_22: When checking operator: User inserted sort "Remove_Duplicates_22.DSLink27_Sort" does not fulfill the sort requirements of the downstream operator "Remove_Duplicates_22"" Please explain ho...

Hi, I have to load data from a range partitioned oracle table, partitioned by date on weely basis. My target table is a non partitioned oracle table. I need to know what oracle stage settings do i need to make to load the data from this partitioned table successfully. The source table contains aroun...

Hi. I need to capture oracle raised exceptions like Inserting Null into Non-nullable field, lookup failure exception, or any other exception that would cause datastage to abort the job while running. I wish to capture such atributes in a separate table. Please suggest if there is a method to do so i...

Hi,
What is the best method to load voluminous data into oracle tables using a parallel job in DS. What stages can i use that would be most helpful in fast loading?

Hi,
What is the best method to load voluminous data into oracle tables using a parallel job in DS. What stages can i use that would be most helpful in fast loading?

Hi, I have developed a parallel job in datastage that loads the target table and assigns an oracle sequence for every record inserted. During update, it only updated the record without incrementing the surrogate key sequence. Earlier the oracle sequence was created with a cache=20 but then the DBA r...

Hi, I have developed a parallel job in datastage that loads the target table and assigns an oracle sequence for every record inserted. During update, it only updated the record without incrementing the surrogate key sequence. Earlier the oracle sequence was created with a cache=20 but then the DBA r...

Thanks for your response . We are calling the job like as follows.: /var/opt/ascential/install/uv/unix/bin/dsjob -run -wait -warn 800 <Project Name> <Job Name> ret_cd="$?" echo "Job Return Code: $ret_cd" /var/opt/ascential/install/uv/unix/bin/dsjob -jobinfo <Project Name> <Job Na...

We are validating flat files using a Datastage job. We validate only till a length of 121 , but at some instances we receive files with higher lengths. The entire file is read into a single column in Sequential file and we select fixed width for the sequential file. In such cases the job currently f...

We have developed a server job. We are using the DsrunJob utlity to execute the server job. if the Job is running for a longer duration then it gives the following return code 141. But if the same job is running for short durations then it does not produce the error. We found a macro in file Sqlext...

We have developed a server job. We are using the DsrunJob utlity to execute the server job. if the Job is running for a longer duration then it gives the following return code 141. But if the same job is running for short durations then it does not produce the error. We found a macro in file Sqlext....

Hi, When i am trieng to complie the simple parallel job it is giving the following error. My job consits of one oracle Enterprise stage as source one transformer and sequential file as target, it is direct mapping from source to target no functions and calculations used in trasformer stage. ##I TFCN...