Need clarification on null to null comparision in informatica
I have the following column in Database
AGE is null for all the records.
I am using this table for lookup in Informatica.
The input ports are in the lookup
The lookup condition is
I_NAME = NAME
I_CITY = CITY
I_AGE = AGE
For incoming record also AGE is null for others not null. If I compare Null to Null in informatica, will it be return the record?
I would like to know what all are the tranformations will support null to null comparision in informatica?
Thanks for your help!
It is not the best practice to compare a null value against a null in lookup transformation.I would suggest you to have a SQL override which replace the null value with some static value (say 1) and in replace the source null values with the same static value 1 before lookup
Compare both the static values in the lookup.I will post the answer for the second one soon.
The lookup will matches null values if the input values is null.The Integration Service evaluates the source NULL equal to a NULL in the lookup .I hope we can use isnull function in the expression to compare two null values.
Thanks for you clarification.