Interested to Buy Any Domain ? << Click Here >> for more details...
How to extract original records at one target & Duplicate
records at one target?
- 12 Answers
- 22280 Views
- I also Faced
- E-Mail Answers
Answer Posted / krishnakanth.ch
yes... add a new column in the sql override by calculating
the count(*) to get how many times the record is repeating.
Using Router we can seperate them into two different
targets.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How do we call shell scripts from informatica?
Explain lookup transformation in informatica
Why do we need informatica?
What are roles and groups and benefits of using them?
How can repository reports be accessed without sql or other transformations?
Can informatica load heterogeneous targets from heterogeneous sources?
what are the deliverables?in your project?
What is incremental aggregation?
Define pmcmd command?
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
Can we create two repositories on same database instance in oracle?
How many dimensions are there in informatica?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What is intricate mapping?
What is the command used to run a batch?
