Interested to Buy Any Domain ? << Click Here >> for more details...
Source is a flat file and want to load unique and duplicate
records separately into two separate targets; right??
- 4 Answers
- 12704 Views
- I also Faced
- E-Mail Answers
Answer Posted / nitin
Create the mapping as below to load Unique records and duplicate records each in separate targets
Source->SQ->Sorter->Aggregator->Router-> Tgt_Unique
-> Tgt_Duplicate
In aggregator use group by on all ports.
and define a port OUTPUT_COUNT = COUNT(*)
In the router define two groups OUTPUT_COUNT > 1 and OUTPUT_COUNT = 1; Connect the outputs from the first group
OUTPUT_COUNT > 1 to tgt_Duplicate and OUTPUT_COUNT = 1 to Tgt_Unique
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what is mean by complex business rule ?
Explain the mapping variable usage example in informatica
explain about unit testing? in real time?
How many ways are there to do 'remove duplicate records in informatica'?
can you please explain me pre session and post session options?
What are the advantages of informatica?
What are mapplets? How is it different from a Reusable Transformation?
What is data caches/ index caches?
Write the different tools in the workflow manager?
What is decode in informatica?
What is informatica? Why do we need it?
Explian the Process of deployment groups in informatica
What is olap (on-line analytical processing?
How to load last n records of file into target table - informatica
Name the different lookup cache(s)?
