DSXchange

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?

A Char field cannot have a value of "".

Any change from a known value (even if "") to NULL is a change.