How to display null values on a target & non-null values on
a target?
Answer Posted / ramesh.b
hi,
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
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is a rank transform?
What is workflow monitor?
What is DR strategy for Informatica project?
What are active transformations.
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
draw informatica architecture 8.6 ?
Differentiate between router and filter transformation?
In informatica workflow manager, how many repositories can be created?
Explain dynamic target flat file name generation in informatica
What is Session and Batches?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
can we override a native sql query within informatica? Where do we do it? How do we do it?
How identifying bottlenecks in various components of informatica and resolving them?
What is the function of look up transformation?
What is informatica worklet?