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
Explain sessions. Explain how batches are used to combine executions?
How do you handle two sessions in Informatica
What is a node in Informatica?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
How can repository reports be accessed without sql or other transformations?
What are the prerequisite tasks to achieve the session partition?
How to generate sequence numbers?
hi real timers . iam waiting for ur reply regarding ETL TESTING
How do you load only null records into target?
Enlist the differences between database and data warehouse.
What are different types of transformations available in informatica?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Different qualification between a related rotate toward the sky and isolates look upward?
What is rank transformation?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C