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?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a rank transform?

1024


What is workflow monitor?

997


What is DR strategy for Informatica project?

1114


What are active transformations.

1592


Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1032


draw informatica architecture 8.6 ?

3820


Differentiate between router and filter transformation?

952


In informatica workflow manager, how many repositories can be created?

1267


Explain dynamic target flat file name generation in informatica

1007


What is Session and Batches?

1040


How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1032


can we override a native sql query within informatica? Where do we do it? How do we do it?

1012


How identifying bottlenecks in various components of informatica and resolving them?

1055


What is the function of look up transformation?

1054


What is informatica worklet?

987