DSXchange

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.

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

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.

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.