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

Answers were Sorted based on User's Feedback



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

Answer / infa

using iif and isnull functions in expression

Is This Answer Correct ?    3 Yes 0 No

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

Answer / 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

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

Answer / murugan

normally router means multiple targets...first taget display
the null valuesw and another records display the non null
values..

Is This Answer Correct ?    3 Yes 1 No

Post New Answer

More Informatica Interview Questions

List the transformation in informatica.

1 Answers   TCS,


One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?

5 Answers   HCL,


in which situations do u go for snowflake schema ?

2 Answers   TCS,


How to extract original records at one target & Duplicate records at one target?

12 Answers  


How the informatica server increases the session performance through partitioning the source?

1 Answers  






How to Join Tables my Source is having 15 table target is one?

4 Answers   TCS,


how can we check whether a particular cache is static or dynamic?

1 Answers   InfoCepts, TCS,


How will u pas the data with out debugger?

4 Answers  


Mention few power centre client applications with their basic purpose?

0 Answers  


Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

0 Answers  


What are mapplets? How is it different from a Reusable Transformation?

0 Answers   Informatica,


What do you mean by filter transformation?

0 Answers  


Categories