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
- 12547 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
Clarify the utilization of aggregator cache record?
Write the prerequisite tasks to achieve the session partition?
Mention a few design and development best practices for informatica?
What is meant by target load plan?
Differentiate between router and filter transformation?
In informatics server which files are created during the session rums?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
How might you approve all mappings in the archive all the while?
Explain direct and indirect flat file loading (source file type) - informatica
What are the different options available for update strategy?
difference between repository database and repository service?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
what is informatica metadata?
tell me about your project functionality
Explain incremental aggregation in informatica
