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
Change Data Capture Triggering false changes
Moderators: chulett, rschirm, roy
Re: Change Data Capture Triggering false changes
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
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
-
- Participant
- Posts: 7
- Joined: Sun Apr 10, 2011 11:30 am
- Location: Delhi
CDC Problem
Hi!
Make sure that your fields are in same order for before and after links..
Make sure that your fields are in same order for before and after links..
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"
![Sad :(](./images/smilies/icon_sad.gif)
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.
The thing is : The source value is : 4.032900
Datastage it converting it to other side " 00004.032899"
![Sad :(](./images/smilies/icon_sad.gif)
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.