how can send duplicate records to one tableand non
duplicate records to one table with simple clear mapping?
- 5 Answers
- 9839 Views
- DELL, I also Faced
- E-Mail Answers
Answer Posted / roshan
hey u have to write a stored procedure to compare each record and then use a router T/R, if the record is non duplicated then it sends to one target and duplicated records to another target.. hope it works..
let me know if better option is available..
infernonag@gmail.com
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Define the various join types of joiner transformation?
What are the differences between a connected lookup and unconnected lookup?
What is meant by query override?
What do you mean incremental aggregation?
What is transformation?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
How do you load first and last records into target table?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is pmcmd command?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What is a mapplet/worklet in informatica?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Explain the pipeline partition with real time example?
How many ways are there to do 'remove duplicate records in informatica'?
What is event and what are the tasks related to it?
