Interested to Buy Any Domain ? << Click Here >> for more details...
how can send duplicate records to one tableand non
duplicate records to one table with simple clear mapping?
- 5 Answers
- 11446 Views
- DELL, I also Faced
- E-Mail Answers
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
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What is option by which we can run all the sessions in a batch simultaneously?
What are different types of transformations available in informatica?
Why do we need informatica?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Tell me about MD5 functions in informatica
can anyone suggest best free Talend data integration training online
Define mapping and session?
What is the difference between informatica 7.0 and 8.0?
Which transformation should we use to normalise the COBOL and relational sources?
What is decode in static cache?
How you know when to use a static cache and dynamic cache in lookup transformation?
tell me 5 session failure in real time how can you solve that in your project?
Difference between Data and Index Caches?
How can you differentiate between powercenter and power map?
