Interested to Buy Any Domain ? << Click Here >> for more details...
How to eliminate duplicate records in informatica mapping?
Explain with an example....
- 1 Answers
- 8591 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
what is SDLC way of code development?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
what is Active lock explain
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What is meant by target load plan?
What is the function of union transformation?
What does role playing dimension mean?
Explain the code page compatibility?
What is a rank transform?
What are the tuning techniques you applied during your last project
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
How do you migrate data from one environment to another?
What is substr in informatica?
What do you mean by enterprise data warehousing?
