Page 1 of 1

Issue with CDC Stage

Posted: Sat Jul 20, 2013 1:57 am
by skyboyfli
Hi,

I am using CDC stage to compare the data with Source Dataset and Target Oracle table with 2 key columns one as numeric and other as Varchar types.
Issue is for only some new records CDC output is getting duplicated to 2.
Please suggest

Posted: Sat Jul 20, 2013 2:19 am
by ray.wurlod
How are your data partitioned?

Posted: Sat Jul 20, 2013 3:05 am
by skyboyfli
Data is Hash partitioned within the stage

Posted: Sat Jul 20, 2013 5:44 am
by ArndW
Are all links partitioned on the keys you are using for CDC ?