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
- 12511 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 enterprise data warehousing?
explain abt ur project architecture?
What is the difference between Active and Passive transformation?
Implementation methodology
Why filter transformation is an active one?
How to handle decimal places while importing a flatfile into informatica?
Which files are created during the session rums by informatics server?
How can we store previous session logs?
What is the command used to run a batch?
Enterprise data warehouse your projects phase by phase explain?
How to load a Dimension ? and how to load a fact table?
What is the status code in stored procedure transformation?
tell me about your project functionality
What can we do to improve the performance of informatica aggregator transformation?
How to load data in informatica ?
