how can send duplicate records to one tableand non
duplicate records to one table with simple clear mapping?
- 5 Answers
- 9399 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
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
How can one identify whether mapping is correct or not without connecting session?
What is the benefit of session partitioning?
Informatica settings are available in which file?
What is the cumulative sum and moving sum?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What is meant by incremental aggregation?
explan ur project architecture?
Can we create multiple integration service on single repository?
How can we improve session performance in aggregator transformation?
What is the commit type if you have a transaction control transformation in the mapping?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What is dimensional table?
How to load last n records of file into target table - informatica
