DSXchange

Hi Guys,

I am new to Datastage. I am doing some POC's on change capture stage.
I had tried the following example using Change capture stage.

Before Dataset,
Code Name
P1 A
P2 B


After Dataset
Code Name
P1 C
P2 B
P1 D

key column is Code and change value is Name.

ResultSet

Code Name ChangeCode
P1 C 3 (Modify)
P2 B 0 (Copy)
P1 D 1 (Insert)

For the third record , i was expecting code 3 (i.e) Modify but got 1 (new record) .

So the key column should not have more than one record for the same value ( in my example P1 ) in the after dataset if we are using change capture stage ???

Kindly help me out guys....


Thanks in advance,

Vikram.

check the linking order.

DS User

The CDC stage cannot handle duplicate keys. You'll need to remove duplicates before processing datasets.

You need to sort your input as change capture stage assumes that the input is sorted

Hello Guys ,
Thanks for your kind reply.

Change capture stage doesnt support duplicate keys even if the input data is sorted.

Thanks again,

Vikram.