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...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

How we can get unique records into one target table and
duplicate records into another target table??

Question Posted / manu

Answers were Sorted based on User's Feedback



How we can get unique records into one target table and duplicate records into another target table..

Answer / durgaprasad

data flow for this one is:

sq-->Aggregater-->Router-->target

in aggregater t/r take 2 output ports and give condition like

uniqe_port---->count(*)=1

duplicate_port--->count(*)>1

connect this one router and in router take 2 groups and
give condition like

uniqgroup=uniqe_port

duplicategroup=duplicate_port


and connect that groups to target

Is This Answer Correct ?    15 Yes 28 No

Post New Answer

More Informatica Interview Questions

&#61656; Code page compatibly –Where all changes are made to handle the scenario.

1 Answers   DELL,

By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?

5 Answers   Keane India Ltd,

What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.

1 Answers   Zensar,

What are the types of caches in lookup?

0 Answers  

How to get EVEN & ODD numbers separately?

8 Answers  

can we use cartesian join in informatica

3 Answers   IBM,

what is size of u r database?

0 Answers  

how to load duplicate row in a target

4 Answers  

What are the measure objects?

0 Answers  

How to generate the HTML output using Informatica.

3 Answers   Wipro,

Howmany ways yoU can update a relational source defintion and what are they?

1 Answers  

How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)

5 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories