Hi
I have a question, let me take an example
I have five columns, first two columns are key columns and last column is an indicator in which 'I' stands for Insert, 'C' stands for Update and 'D stands for Delete. For first run, I will have all I's which will be all inserts
Col1 Col2 Col3 Col4 Col5
A 1 abc ab I
A 2 abc aa I
B 1 aa bb I
B 2 bb aa I
C 1 aa aa I
C 4 bb bb I
For second run
Col1 Col2 Col3 Col4 Col5
A 1 aa ab C
A 2 bb aa C
B 1 aa bb I
B 2 bb aa D
C 6 aa bb I
How can I do it in datastage, my target is DB2, and source comes as files
Thanks in advance
Insert,delete,update based on Indicator
Moderators: chulett, rschirm, roy
Thankyou for your replychulett wrote:Three targets with the appropriate action in each and constraints based on the last column's value. ...
I tried the same, but when some records are passing to delete stream, all records are getting deleted in the database.
Database is DB2, and using DB2 Api stage.
Delete without clearing option I picked
based on first two key columns. but all existing records are getting deleted
-
- Participant
- Posts: 342
- Joined: Tue Nov 04, 2008 10:38 am
- Location: Chennai, India