Here are my Current dataSet (before) and Previous Dataset (After). What is the expected output code in DataSatage
"" Blank String
Field 1 and Field 2 are Change Values. Key =A and Key =B are two records for which I want to know the expected output from the CDC stage.
Input filed------------Key-----Before -------After------Is Edit code set to 3
Field1 (Varchar)-----A ------- "" ------------NULL------Is this a change?
Field2 (char)-------- B ------- "" ------------NULL------Is this a change?
Where my key is B (Field 2)..I am not seeing the CDC stage capture the value as a change. I dont want to do null handling on char fields.
Is this a know issue on how datastage does compasrisons with NULL when using CDC?
Change capture Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: