Change Data Capture issue.

Shadab_Farooque · Post by **Shadab_Farooque** » Wed Sep 26, 2007 3:22 am

I am using Change Data Capture Stage.

I am comparing 2 Oracle table having 6 million records each.Both the Tables are identical.
2nd table is the copy of 1st table.

I have not done any changes in the tables.However,I am getting 20,000 records as changed/updated.When actually there are no changes.

Partitioning is set to auto in Change Data Capture Stage.And I am sorting the incoming Data(Asc) through SORT Stage.

Please help how to get rid of the above error

balajisr · Post by **balajisr** » Wed Sep 26, 2007 3:33 am

Is the metadata for before and after datasets in change capture stage same?

JoshGeorge · Post by **JoshGeorge** » Wed Sep 26, 2007 5:52 am

Change Data Capture (CDC) needs more care to be given. Reading the relevant help document is the first step.

Also make sure:

In the input tab of your Change Capture stage you have used the same partition on the same partition keys. Also your sorting keys are the same and in the same order.

Minhajuddin · Post by **Minhajuddin** » Wed Sep 26, 2007 9:08 am

How many nodes are you running this on?

And, have you tried taking one record from the output and comparing all columns in the two input columns for that record?

This may help you find the problem.......