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.
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.