Home > Software > Data-Warehouse > Informatica
Interview Questions   Tutorials   Discussions   Programs   

Informatica - How to display null values on a target & non-null values on a target?




2271
views
asked marvit December 5, 2014 11:52 PM  

How to display null values on a target & non-null values on a target?


           

2 Answers



 
answered By Nagapuri   0  

Just a brief explanation.

normally router means multiple targets...take 2 groups first group condition isnull and second group condition not isnull.first group gives the null values and second group gives the non null values.

source-->sq-->expression-->router-->2 targets

Router 1st condition : isnull 2nd condition : not isnull

flag   
   add comment

 
answered By vishnoiprem   0  
using iif and isnull functions in expression 
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert