Splitting a Sequential File
Posted: Thu Aug 03, 2006 12:51 am
Dear All,
I have created a server job with one Source (Sequential) One transformer and one Target (DB2). The mappings are quite direct. The Target's Update Action='Update existing or insert new rows'.
I would like to do the following:
Split the Source into 2 links one for update and one for Insert and put each of them into a sequential file. How do i be able to diff between the records to be inserted and updated.
Appreciate all the assistance.
Thank you in advance.
Regards,
holymac
I have created a server job with one Source (Sequential) One transformer and one Target (DB2). The mappings are quite direct. The Target's Update Action='Update existing or insert new rows'.
I would like to do the following:
Split the Source into 2 links one for update and one for Insert and put each of them into a sequential file. How do i be able to diff between the records to be inserted and updated.
Appreciate all the assistance.
Thank you in advance.
Regards,
holymac