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

in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?

9 Answers   Target,

what is polling?

1 Answers   Informatica,

Explain factlessfact table with scenario

1 Answers   HCL,

What is a surrogate key?Why we use it in a mapping?Pl give an example.

4 Answers   PCS,

in which situations do u go for starflake schema ?

6 Answers   TCS,




Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,

7 Answers   Tech Mahindra,

Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.

1 Answers  

performance wise which one is better in joiner and lookup transformation

2 Answers  

Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance

2 Answers  

What's the layout of parameter file (what does a parameter file contain?)?

0 Answers   Cognizant,

Can we schedule a workflow(not a session) to run after completition of another workflow? Can we make a workflow depend on completition of another one?

2 Answers   GE,

How do you take care of security using a repository manager

2 Answers  

For more Informatica Interview Questions Click Here
Categories