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
Describe the impact of several join conditions and join order in a joiner transformation?
define galaxy repository in informatica
What are the popular informatica products?
Explain the difference between mapping parameter and mapping variable?
What is dynamic cache?
How to go to the older version for a mapping?
Explain sessions?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Can we create a node as a gateway node and the same node can be assigned to a grid?
Define Pmrep command?
How will the document be delivered to me?
What is the Rank index port in Rank transformation?
What is a passive transformation?
Explain how many types of dimensions are available in informatica?
How do you load unique records into one target table and duplicate records into a different target table?