how can send duplicate records to one tableand non
duplicate records to one table with simple clear mapping?
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
What are the performance considerations when working with aggregator transformation?
How many numbers of sessions can one group in batches?
What you know about transaction control transformation?
What are mapplets?
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 data caches/ index caches?
What is informatica worklet?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Explain dynamic target flat file name generation in informatica
Can anyone tell me the new features in Informatica 9 Version?
How to start a workflow using pmcmd command?
What do you mean by filter transformation?
What is the sequence generator transformation in informatica?
What is a grid in Informatica?
Where is metadata stored?