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
Can we create a node as a gateway node and the same node can be assigned to a grid?
Describe an informatica powercenter?
What is the use of code page?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
how to load rows into fact table in data warehouse
What is the difference between writing a joiner query in ANSI style and THETA style?
How to do unit testing in informatica? How to load data in informatica ?
Different sorts of metadata that stores in the storage facility?
Explain joiner transformation in informatica
explain one complex mapping with logic? sales project?
How do you load only null records into target?
Explain the use of aggregator cache file?
What is the advantage of informatica?
How might you approve all mappings in the archive all the while?
How to create a non-reusable instance of reusable transformations?