Link variables

dnat · Post by **dnat** » Mon Dec 07, 2009 4:00 am

Hi,

I want to capture the rejected rows while it is being upserted in a oracle table.

Table1-->Transformer-->Table2.

There is a key column in Table 1 and i want to update the records corresponding to the key column as Error_code=Y in table1 where i am not able to insert/update the records in table2.

In the Transformer i am trying to use DSLink.Rejected or DSLink.Rejectcode, but that option is not available. It is showing only "OTHERWISE" option.

I am using the version 7.5.3..

Any idea what could be the problem.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Mon Dec 07, 2009 6:15 am

The reject in parallel jobs comes from the table2 and not from transformer.

dnat · Post by **dnat** » Mon Dec 07, 2009 9:32 pm

yeah..But with the link variables i think we should be able to capture it from the transformer itself.

Since the key in table1 is a column which i am not going to use in table2, when i capture the rejects from oracle stage(table 2), i wont get that column with which i can update the table 1.

chulett · Post by **chulett** » Mon Dec 07, 2009 9:47 pm

dnat wrote:yeah..But with the link variables i think we should be able to capture it from the transformer itself.

No, because that's not the way it works in parallel jobs.