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 types of caches in lookup?
How to open an older version of an object in the workspace?
What is option by which we can run all the sessions in a batch simultaneously?
How to use pmcmd utility command?
expain about the tune parameters?
How to extract sap data using informatica?
Please let me know how to make Data masking in informatica..
What is decode in static cache?
What is the difference between Active and Passive transformation?
Explain lookup transformation source types in informatica
What is meant by pre and post session shell command?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Mention some types of transformation?
What is the difference between writing a joiner query in ANSI style and THETA style?
What are the designer tools for creating transformations?