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

What is metadata reporter?

1 Answers   Informatica,


Target is zero file and how can you send the email?

2 Answers   Bank Of America,


what is data driven?

5 Answers   TCS, Wipro,


What are multi-group transformations?

0 Answers   Informatica,


Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

0 Answers   HCL,


Which is better performance wise database or file?How?

2 Answers   TCS,


What is the advantage of persistent cache? When it should be used.

1 Answers   Wipro,


What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

0 Answers  


following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?

8 Answers   BRAD, TCS,


How do you Merge multiple Flat files for example 100 flat files with out using Union T/F

4 Answers   IBM,


what are the differences between powercenter 8.1 and powercenter 8.5?

2 Answers  


what is DSS?

3 Answers  


Categories