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 we can get unique records into one target table and
duplicate records into another target table??

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

My source table having some records ,i want load 1st record and last record into one target?

3 Answers   iGate,


What is the difference between writing a joiner query in ANSI style and THETA style?

0 Answers   TCS,


There are 100 lines in a file. How to print line number 31-50 and 81-90 in unix with a single command.

2 Answers   L&T,


What is a difference between complete, stop and abort?

0 Answers  


What is confirmed dimension?

3 Answers  


what are the difference between Informatica 7.1 and 8.1?

6 Answers  


Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

3 Answers   Infotech,


any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com

1 Answers  


What is workflow variable? When we use workflow variable? Can any one explain me with one example???

2 Answers   TCS,


I have a scenario with lookup table. in that lookup table have colomns, but i need to process only 10 colomns out of 50. Please te me how can we acheive it?

6 Answers   TCS,


what is mapping parameter and mapping variables

1 Answers   BirlaSoft,


Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how

1 Answers   IBM,


Categories