Source is a flat file and want to load unique and duplicate
records separately into two separate targets; right??
- 4 Answers
- 11951 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 standalone command task?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
Explain what transformation and how many are there in informatica?
How to load last n records of file into target table - informatica
How to join three sources using joiner?
What is the function of union transformation?
What does role playing dimension mean?
Design time, run time. If you don't create parameter what will happen
can u any challenge your project?
how to load rows into fact table in data warehouse
Explain about cumulative Sum or moving sum?
Explain sessions?
Explain pushdown optimization and types in informatica
Informatica settings are available in which file?
