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
- 41712 Views
- Deloitte, IBM, iGate, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What are the tasks that source qualifier perform?
what is size of u r database?
Which transformation is needed while using the Cobol sources as source definitions?
How you know when to use a static cache and dynamic cache in lookup transformation?
Explain what are the different types of transformation available in informatica.
What is powercenter on grid?
How to convert multiple rows to single row (multiple columns) in informatica
have u done any performance tuning? how u ll do?
How to extract the informatica rejected data?
Explain the code page compatibility?
Differentiate between Load Manager and DTM?
Explain the mapping variable usage example in informatica
What is the need for an etl tool?
Explain how to import oracle sequence into informatica?
What is a connected transformation?
