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
How does the aggregator transformation handle null values?
Have you worked with/created Parameter file
What are active and passive transformations?
What is the difference between informatics 7x and 8x and what is latest version?
update strategy transformation in informatica
How to handle decimal places while importing a flatfile into informatica?
Did u used latest transformations of 8.6.0? for what?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is target load order?
Define filter transformation?
What is a connected transformation?
What are the different options available for update strategy?
Which version configuration tool used in ur project?
How can we create index after completion of load process?
How might one distinguish in the case of mapping is right or not without associating session?