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??
- 11 Answers
- 40668 Views
- Deloitte, IBM, iGate, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
what is filelist concept in informatica
How will you display "Mr" for male & "Mrs" for female in target table?
What is option by which we can run all the sessions in a batch simultaneously?
What are the limitations of joiner transformation?
What is mapping debugger?
Define Update Override?
How many input parameters can exist in an unconnected lookup?
What is the difference between a shortcut of an object and copy of an object? Compare them.
what is bitmap index? did u use it?and how to use it in informatica
I still need further explanation about the difference between active and passive transformation with some examples.Thank You
What is junk dimention?
What is data movement mode in Informatica and difference between them?
Teradata 
