Interested to Buy Any Domain ? << Click Here >> for more details...
How to eliminate duplicate records in informatica mapping?
Explain with an example....
- 1 Answers
- 8481 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / venkatesh
by using aggrigator transformation we can eliminate
duplicate records in informatica
The flow will be like this
source--->aggrigator----->target
in aggrigator group by all ports then the out put is only
unique records
connect it to the target
2)we can do it by sorter also in sorter if we enable select
distinct then it will gives unique row
3)if u r source is database then u can select distinct in
sourcequalifier it self
| Is This Answer Correct ? | 23 Yes | 0 No |
Post New Answer View All Answers
How might you approve all mappings in the archive all the while?
What is different between the data warehouse and data mart?
What is an aggregator transformation?
Describe an informatica powercenter?
What are the conditions needed to improve the performance of informatica aggregator transformation?
how to create user defined function (udf) in informatica
Define enterprise data warehousing?
What are the restrictions of union transformation?
What is the Process to creating lookup transformation in informatica
What is a mapplet/worklet in informatica?
Which files are created during the session rums by informatics server?
What are roles and groups and benefits of using them?
What do think which one is the better joiner or look up?
Quickly characterize reusable change?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
