Change Data Capture Triggering false changes

[piyu]

Hi,

I have a CDC job which is triggering an update when there is no change at all. I have made sure that I am comparing apples to apples and even trim for ascii nulls for char fields.

Checked the forum, closest match : viewtopic.php?t=133411&highlight=change+capture+stage

Ran the CDC stage in sequential with one record only over and over again.Not able to figure it out. Help will be much appreciated.

Thanks,
Anu

[SURA]

Hi

Sometime this will be tricky. Try like below will help you.

Step 1. Do you applied any sort / partitions?. If so apply it in both links.
Step 2. After the first run, use the key col alone. If you have more than 1 key col, add one by one.

These type of appraoch will help you to figureout the issue.

DS User

[piyu]

I have run the change capture stage in sequential and my before and after have only one record. Also, I have one key only

Even converted all char fields to varchar and tried.

[yammanur.dwhcareer]

Hi!

Make sure that your fields are in same order for before and after links..

[piyu]

Got the error: A decimal field, both sides same precision. On one side it is " 00004.032898" and other side " 00004.032899"

The thing is : The source value is : 4.032900
Datastage it converting it to other side " 00004.032899"



Any reason why datastage is reading 4.032900 as 4.032899 and then after reading in 4.032899, converting that to 4.032898?

The decimal is defined as (11,6) throughout.

[piyu]

Figured it out. The DB2 connector stage, which is my source for data, is also the source of this issue.

Note, it does not do this for every value in the column:!: Very selective!

I used ODBC connector in its placed and now I am good to go!

Thanks.