Nullable check in change capture

[Ragunathan Gunasekaran]

Hi ,
I am using a change capture stage and the before and after datasets have nullable varchar2 columns..My change capture stage is not working fine .. I am not sure whether the Change capture stage would compare the Null in varchar2 columns ... How do i check whether the change capture stage is treating records with Null in before and after datasets as copy records not as ipdate records

[ray.wurlod]

Since NULL can not be compared to anything (even another NULL) I believe that what you are trying to do is not valid. Handle the nulls by converting to in-band null or dropping those rows upstream of the Change Capture stage.