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.
Transformer Constraint Data Filtering Issue
Moderators: chulett, rschirm, roy
Transformer Constraint Data Filtering Issue
Regards
Kiran
Kiran