Data getting added in CDC stage
Moderators: chulett, rschirm, roy
Data getting added in CDC stage
The Data from CDC stage is getting added each and everytime i run the job,
Note: I am just comparing the same datasets i.e same data.
The Key column i am using for cdc is a varchar column and i have trimmed on both the columns before doing cdc....not sure what else is missing. Yes also i have done Hash partitioning on the same key and sorted it remove dups if there are any.
Note: I am just comparing the same datasets i.e same data.
The Key column i am using for cdc is a varchar column and i have trimmed on both the columns before doing cdc....not sure what else is missing. Yes also i have done Hash partitioning on the same key and sorted it remove dups if there are any.
-
- Participant
- Posts: 152
- Joined: Tue Jan 13, 2009 8:59 am
1. Check whether you have same number of columns in your before and after link.
2. Verify the key column and change columns, and see whether you add any surrogate or generated column in your before and after column list or not.
3. Check whether you are doing any kind of transformation before loading into your target table.
2. Verify the key column and change columns, and see whether you add any surrogate or generated column in your before and after column list or not.
3. Check whether you are doing any kind of transformation before loading into your target table.
1. Check whether you have same number of columns in your before and after link.
2. Verify the key column and change columns, and see whether you add any surrogate or generated column in your before and after column list or not.
3. Check whether you are doing any kind of transformation before loading into your target table.
2. Verify the key column and change columns, and see whether you add any surrogate or generated column in your before and after column list or not.
3. Check whether you are doing any kind of transformation before loading into your target table.
1. Check whether you have same number of columns in your before and after link. >>> Yes
2. Verify the key column and change columns, and see whether you add any surrogate or generated column in your before and after column list or not. >>> No there are no surrogate key.
3. Check whether you are doing any kind of transformation before loading into your target table. >> just plain inserts.
2. Verify the key column and change columns, and see whether you add any surrogate or generated column in your before and after column list or not. >>> No there are no surrogate key.
3. Check whether you are doing any kind of transformation before loading into your target table. >> just plain inserts.