DSXchange

Hi,
I want to drop records if both column1 and column2 are null.

Source & Target columns are defined as nullable. I am using xfrm constraint with following condition however it is dropping all records if either is null
IsNotNull(COL1) And IsNotNull(COL2)

ex.
source 50K records.
expected 3 records should reject where 10k rejected as one of them is null but not both.

Thank you for your help.

Yup - your constraint says both need to be non-null to pass. You want an or rather than the and there to say it's only bad if both are null.