Skip navigation
Contact Us
2231 Views 3 Replies Latest reply: Jan 19, 2012 1:31 AM by Venkat Byrapudi RSS
Venkat Byrapudi Master 891 posts since
Mar 25, 2010
Currently Being Moderated

Jan 18, 2012 9:38 PM

Need Help on Null to Null comparision in informatica?

Experts,

 

Need clarification on null to null comparision in informatica

 

I have the following column in Database
1. NAME
2. CITY
3. AGE

 

AGE is null for all the records.

I am using this table for lookup in Informatica.

 

The input ports are in the lookup

1. I_NAME
2. I_CITY
3. I_AGE

 

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!

 

Regards,
venkat

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points