DSXchange

Hello there, This is the first time I am executing a Parallel job. I am getting the following error. Can any one help me in correcting the error. ##E TBLD 000000 10:13:57(000) <main_program> Error when checking composite operator: Subprocess command failed with exit status 65280 ##E TFSR 000019 10:1...

Hello there, I am trying to load the columns of a table in the target database. The problem is that some of these columns get data from one table and the remaining columnns from a different table. Is there any way that I could load some columns first and later on load the remaining columns from a di...

Hello there, I am trying to load the columns of a table in the target database. The problem is that some of these columns get data from one table and the remaining columnns from a different table. Is there any way that I could load some columns first and later on load the remaining columns from a di...

Hello Michael,

Thank you very much for your help. I think I got the solution for my problem.

-Yamini

Hello there,

Can anyone explain to me how to link two or more tables in the target database with a common column 'A'. Actually I am populating this(common) column in a table and tying to link this column with the other two tables.

Thanks in advace.
-Yamini

Hello there,

Can anyone explain to me how to link two or more tables in the target database with a common column 'A'. Actually I am populating this(common) column in a table and tying to link this column with the other two tables.

Thanks in advace.
-Yamini

Hi,
Thank you for your help.
-Yamini

Hello there,

I am trying to archive the error log generated when I run a job. My intension is to make this error log available in future to go through the errors generated. Can anyone tell me how to accomplish this.
Thanks in advance.
-Yamini

Hello there,

I am trying to archive the error log generated when I run a job. My intension is to make this error log available in future to go through the errors generated. Can anyone tell me how to accomplish this.
Thanks in advance.
-Yamini

Hi,
Thank you very much for your help.
-Yamini

Hello there, I am trying to link surrogate key column of table A to a column in table B. My intension is to link these two columns in the sense to make column in table A as a foreign key which refers to the column in table B. I hope I am clear with my problem. Can anyone explain to me how to accompl...

Hello there, I am trying to link surrogate key column of table A to a column in table B. My intension is to link these two columns in the sense to make column in table A as a foreign key which refers to the column in table B. I hope I am clear with my problem. Can anyone explain to me how to accompl...

Hello there,

I am trying to decript some information from my source table, based on an algorithm, and load it ito my taget tables. Can anyone explain to me how to use the decripting algorithm in DataStage.

Thanks in advance.

Hello there,

I am trying to decript some information from my source table, based on an algorithm, and load it ito my taget tables. Can anyone explain to me how to use the decripting algorithm in DataStage.

Thanks in advance.

Thank you all for your help. Have a nice day. Hello, I am trying to map some columns in source table to columns in target table. The problem is that for some target table columns there are no source columns specified. I am asked to fill that columns with defaults like 'Null' or to just leave them bl...