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

what are factless facts? And in which scenario will you use such kinds of fact tables.

0 Answers  


can anyone explain me about sales project in informatica?

8 Answers   MBT, Satyam,


i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486

2 Answers   Accenture,


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

3 Answers  


What are Target Options on the Servers?

1 Answers  


How can we delete duplicate rows from flat files?

0 Answers  


how can u load the data in time dimension?

3 Answers  


What are Dimensional table?

0 Answers   Informatica,


Why do we use DSS database for OLAP tools?

2 Answers  


What is meant by query override?

0 Answers  


From where you extract the data, how you did it into informatica? explain....

1 Answers   Accenture, Unisoft Infotech,


what is shared Cache. when we will use shared Cache?

4 Answers  


Categories