Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

performance wise which one is better in joiner and lookup transformation?why?explain clearly?

4 Answers   IBM,


How do you implement configuration management in Informatica?

1 Answers  


In a sequential batch can you run the session if previous session fails?

4 Answers  


Write the different tools in the workflow manager?

0 Answers  


How do you load alternate records into different tables through mapping flow?

0 Answers  


What are the out put files that the informatica server creates during the session running?

2 Answers  


How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

0 Answers  


How to go to the older version for a mapping?

0 Answers  


what are the unix commands to start the wrk flow ?

4 Answers   Accenture, TCS,


What is the format of informatica objects in a repository?

0 Answers  


Differentiate between mapping parameter and mapping variable?

1 Answers  


whatis the default data driven operation in informatica

2 Answers  


Categories