capturing reasons of rejected rows in a table
Posted: Sat Jun 23, 2007 4:06 pm
Presently I am capturing filtered and rejected rows into db2 table using following constraints at transfomer stage.
LNK_Write_Account_Mst_Filtered--->
LNK_Write_Rejects--->
where LNK_Write_Account_Mst is input link
My requirement is to capture also exact reason for each rejected rows into db2 table along with rejected rows.
Could you anyone of you let me know how to do this?
or any reference of the previous post would also help me.
Thanks in advance
LNK_Write_Account_Mst_Filtered--->
Code: Select all
LNK_Write_Account_Mst.REJECTEDCODE = DSE.NOERROR And LNK_Write_Account_Mst.REJECTED
LNK_Write_Rejects--->
Code: Select all
LNK_Write_Account_Mst.REJECTEDCODE
My requirement is to capture also exact reason for each rejected rows into db2 table along with rejected rows.
Could you anyone of you let me know how to do this?
or any reference of the previous post would also help me.
Thanks in advance