Issue with CDC Stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
skyboyfli
Participant
Posts: 32
Joined: Fri Jun 04, 2010 8:21 am
Location: hyd
Contact:
Contact skyboyfli

Issue with CDC Stage

Post 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
this is nice
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

How are your data partitioned?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
skyboyfli
Participant
Posts: 32
Joined: Fri Jun 04, 2010 8:21 am
Location: hyd
Contact:
Contact skyboyfli

Post by skyboyfli »

Data is Hash partitioned within the stage
this is nice
Top
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Contact ArndW

Post by ArndW »

Are all links partitioned on the keys you are using for CDC ?
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”