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 send duplicates to one target and unique rows to one
target?target is empty

Answer Posted / naresh araveti

source> dynamic lookup>router,2 conditions 1. condition
if column_lkp port is null then insert into target1(unqie)
2. condtion if COLumn_lkp port is not null then insert into
target2(duplicates)

Is This Answer Correct ?    4 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you generate reports in informatica?

1082


Explain how many types of dimensions are available in informatica?

1172


Where do we use mapping variables in informatica?

1121


Explain the different kinds of facts.

1021


Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1188


what is the complex transformation you used in informatica

2623


What are junk dimensions?

1112


explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2199


Describe data concatenation?

1125


How do you update the records with or without using update strategy?

1161


how to load dimension table and fact table. plz tell me the steps.

2142


Name at least 5 different types of transformations used in mapping design and state the use of each.?

1200


How to load the data from people soft hrm to people soft erm using informatica?

1067


How can we use mapping variables in informatica?

1124


What is the maplet?

1203