Source is a flat file and want to load unique and duplicate
records separately into two separate targets; right??
- 4 Answers
- 12005 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
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What are the databases that informatica can connect to windows?
what is size of u r database?
How many number of sessions can one group in batches?
update strategy transformation in informatica
What all are steps in up gradation of Informatica server?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What are the new features of informatica 9.x developer?
Slowly changing dimensions, types and where will you use them
Mention few power centre client applications with their basic purpose?
What is rank transform?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
what is unit testing?tell me proceedure
What is a joiner transformation?
What is enterprise data warehousing?
