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

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

0 Answers   IBM,


Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why?

6 Answers   iFlex, Morgan Stanley,


In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?

4 Answers   Puma,


What are the types of data that passes between informatica server and stored procedure?

1 Answers   Informatica,


COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

0 Answers  


As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?

1 Answers  


What is the Rankindex in Ranktransformation?

7 Answers  


What are the different types of Type2 dimension maping?

2 Answers   CTS,


What is power center repository?

1 Answers  


How do you manage the Parameter files while migrating your data from one environment to another environment?

0 Answers  


whether Sequence generater T/r uses Caches? then what type of Cache it is

7 Answers   Accenture,


if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000

7 Answers  


Categories