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
- 12687 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
Explain in detail scd type 2 through mapping.
What is domain in terms of informatica?
What is the meaning of decode in informatica?
What is data transformation manager process?
What is joiner transformation in informatica?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What is native users?
Separate from a database, an information bazaar, and an information stockroom?
can u give example for factless fact table
How we can create indexes after completing the loan process?
What is expression transformation?
What is an unconnected transformation?
What is event and what are the tasks related to it?
How do you load first and last records into target table?
As union transformation gives UNION ALL output, how you will get the UNION output?
