how can send duplicate records to one tableand non
duplicate records to one table with simple clear mapping?

Answer Posted / rajan raorane

You can use Router where One update strategy is directy
connected to Target table while other update strategy must
be followed by sorter with DISTINCT check which shud be
further connected to target table

This will differntiate Duplicate and non-duplicate records
in target table

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are active and passive transformations?

656


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

624


Performance tuning( what you did in performance tuning)

1491


can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10282


What is workflow? What are the components of the workflow manager?

646






hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

1652


-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

4994


Explain in detail about scd type 1 through mapping.

593


How to extract the informatica rejected data?

757


What is a mapplet/worklet in informatica?

692


What is repository manager?

538


In informatics server which files are created during the session rums?

639


What is mapplet in informatica?

600


What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

795


What is a sorter transformation?

669