Change Data Capture stage
Posted: Thu May 01, 2008 1:36 pm
Hi,
I have requirement where i have to compare a
dataset data with data in DB2 table .
I am using a CDC stage to do this,I have the
following settings
Change Mode:Explicit Keys,All Values
DropOutput for copy=True
DropOutput for Delete=False
DropOutput for Edit=False
DropOutput for Insert=False
I have 3 keys ,i am sorting and hash partitioning them in the CDC stage.
I have checked the datatypes from both the before link(DB2) and after link(Dataset).
I have 12 other values which have to be compared.Most of the values are
varchar,(which i have trimmed) and 2 values are decimal.
I am testing this job with just one record which are same in both before and
after links.As the record is same i should not get any output from the
CDC stage,but i get one record with Change code 3(which means Edit).
keys are as below
key1 key2 Key3
A 1 .
I have put peek stages before the data is passed into CDC stage and see that the
data is same in both before and after links.The record is not supposed to come out of the
CDC stage.
Can some one guide me in this matter if i am missing some thing.
Thanks
I have requirement where i have to compare a
dataset data with data in DB2 table .
I am using a CDC stage to do this,I have the
following settings
Change Mode:Explicit Keys,All Values
DropOutput for copy=True
DropOutput for Delete=False
DropOutput for Edit=False
DropOutput for Insert=False
I have 3 keys ,i am sorting and hash partitioning them in the CDC stage.
I have checked the datatypes from both the before link(DB2) and after link(Dataset).
I have 12 other values which have to be compared.Most of the values are
varchar,(which i have trimmed) and 2 values are decimal.
I am testing this job with just one record which are same in both before and
after links.As the record is same i should not get any output from the
CDC stage,but i get one record with Change code 3(which means Edit).
keys are as below
key1 key2 Key3
A 1 .
I have put peek stages before the data is passed into CDC stage and see that the
data is same in both before and after links.The record is not supposed to come out of the
CDC stage.
Can some one guide me in this matter if i am missing some thing.
Thanks