CDC not giving desired results
Moderators: chulett, rschirm, roy
CDC not giving desired results
I am using CDC stage in one of my parallel job. Initially, my target table is empty. First time CDC outputs 10 rows (which are new rows). Next time when I run job it gives same 10 rows for update with change_code=3, which is not correct because this time it should output no rows.
Can we clarify exactly what it is you are doing, please? This "CDC stage" you are using... I'm guessing that this is not the Change Capture Stage but rather the CDC Transaction Stage and you have InfoSphere Change Data Capture running against your source database - something akin to what is shown here?
Details are required before anyone can truly help.
Details are required before anyone can truly help.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
There can be many reasons for getting all records for update. But since you are seeing every record as update here are my wild guesses.
1. You are writing to oracle database with APT_ORACLE_PRESERVE_BLANKS flag set to false and while loading those blanks are ommited.
2. You are unsupported character getting coverted to junk while inserting in to database and when compared back with correct character with junk, its marking it as update.
These are just a few most obvious ones but there are a few more, so I think we will be able to point out the actual cause only if you explain your job design.
1. You are writing to oracle database with APT_ORACLE_PRESERVE_BLANKS flag set to false and while loading those blanks are ommited.
2. You are unsupported character getting coverted to junk while inserting in to database and when compared back with correct character with junk, its marking it as update.
These are just a few most obvious ones but there are a few more, so I think we will be able to point out the actual cause only if you explain your job design.
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.
-
- Premium Member
- Posts: 224
- Joined: Tue Sep 24, 2002 7:32 am
- Location: Denver, CO USA