Search found 3 matches
- Thu Jan 14, 2016 9:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Change Capture stage with duplicate after link
- Replies: 3
- Views: 1988
- Wed Jan 13, 2016 12:30 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Change Capture stage with duplicate after link
- Replies: 3
- Views: 1988
Change Capture stage with duplicate after link
before link KEY1,KEY2,Data1,Data2 After Link KEY1,KEY2,Data1,Data2 KEY1,KEY2,Data3,Data4 as you can see there is duplicate key value in after link I set up on job with Change capture with reject copy option. but i got KEY1,KEY2,Data3,Data4 as new record and should be insert and duplicate error when ...
- Tue Jul 12, 2011 4:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Add one key collmun which stage should i use
- Replies: 1
- Views: 1275
Add one key collmun which stage should i use
We have one data set : Key1,Key2 and Key3 The request is : add one column "Number" to current data the "Number " should be added to the record that has the same value of Key1. the initial "Number" is 1 and add steps by 1 of others such as: Key1 Number US 1 US 2 JP 1 JP ...