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

Explain pushdown optimization $pushdownconfig parameter - informatica

0 Answers   Informatica,


Explain load alternative records / rows into multiple targets - informatica

0 Answers   Informatica,


Suppose i have 10000 records.First time i have to load 1 to 1000 records and second run i have load 1000 to 2000 records and third load i have to load 2000 to 3000 rows .How will achieve

15 Answers   TCS,


Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

0 Answers  


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

4 Answers  


what are the perameter and variable?

3 Answers   IBM,


Why use the lookup transformation ?

2 Answers   Informatica,


what is the diff b/w target load plan and cbl?

3 Answers   CTS, iGate,


to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?

3 Answers   IBM,


What are the tasks that source qualifier perform?

0 Answers   Informatica,


Informatica software installation 8.1/7.1.3/7.1 with oracle 10g database (optional Teradata v2R6)

1 Answers  


can anyone suggest best free Talend data integration training online

0 Answers  


Categories