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
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is the advantage of informatica?
What is a sorter transformation?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What is data transformation manager process?
Can we create two repositories on same database instance in oracle?
What is the different lookup cache(s)?
What is workflow manager?
Reusable transformation and shortcut differences
How you can differentiate between connected lookup and unconnected lookup?
How to do unit testing in informatica?
What is the format of informatica objects in a repository?
What is workflow monitor?
What are the settings that you use to configure the joiner transformation?