how can send duplicate records to one tableand non
duplicate records to one table with simple clear mapping?
- 5 Answers
- 9834 Views
- DELL, I also Faced
- E-Mail Answers
Answer Posted / radhakrishnansk
Considering the source as flat file.
src-->Src qual ---> sorted transfomation -->trgt
|
|---> trgt
In sorted transformation, we can choose distict in
properties. So the duplicate is avoided.
correct me if I am wrong
| Is This Answer Correct ? | 1 Yes | 11 No |
Post New Answer View All Answers
What are pre and post-session shell commands?
What are the types of data warehouses?
What are active transformations.
How to load data in informatica ?
What is workflow? What are the components of the workflow manager?
Differentiate between sessions and batches?
How can we improve session performance in aggregator transformation?
What is the function of look up transformation?
Where is metadata stored?
Which transformation should we use to normalise the COBOL and relational sources?
I have a flat file, want to reverse the contents of the flat file
Tell me about Propagate functions in informatica
What is session task and command task?
What is the Rank index port in Rank transformation?
How to delete duplicate row using informatica?
