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


Please Help Members By Posting Answers For Below Questions

What are the types of caches in lookup?

560


How to open an older version of an object in the workspace?

604


What is option by which we can run all the sessions in a batch simultaneously?

653


How to use pmcmd utility command?

572


expain about the tune parameters?

1870






How to extract sap data using informatica?

595


Please let me know how to make Data masking in informatica..

1255


What is decode in static cache?

584


What is the difference between Active and Passive transformation?

624


Explain lookup transformation source types in informatica

686


What is meant by pre and post session shell command?

610


how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

1960


Mention some types of transformation?

597


What is the difference between writing a joiner query in ANSI style and THETA style?

1903


What are the designer tools for creating transformations?

669