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

if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs

1 Answers  


Different qualification between a related rotate toward the sky and isolates look upward?

0 Answers  


What is a dimensional model?

0 Answers  


in oracle write query yourname+1 from dual

5 Answers  


What is the difference between STOP and ABORT options in Workflow Monitor?

0 Answers  


1:when we develop a project what are the performance issue will raise?? KPIT 2:if a table have INDEX and CONSTRAINT why it raise the performance issue bcoz when we drop the index and disable the constraint it performed better??KPIT 3:what are unix commands frequently used in informatica??

1 Answers   KPIT,


Kimball and Inmon methodologies?

2 Answers  


what is the need of session partitioning... how it is useful in real time

3 Answers   Amazon,


What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?

5 Answers  


Which are the different editions of informatica powercenter that are available?

0 Answers  


Whats the difference between informatica powercenter server, repositoryserver and repository?

0 Answers  


what is target load plan

2 Answers   Cap Gemini,


Categories