Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


How to eliminate duplicate records in informatica mapping?
Explain with an example....



How to eliminate duplicate records in informatica mapping? Explain with an example......

Answer / 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

More Informatica Interview Questions

What is the meaning of decode in informatica?

0 Answers  


Hello all, In SOA architecture i.e 8.6 , What is mean by node exactly?

4 Answers  


In real time scenario where can we use mapping parameters and variables?

4 Answers   CSC, CSE,


how did u understand business requirement?

2 Answers   TCS,


How the dimensions will be loaded?

0 Answers   HCL,


I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan

1 Answers  


how to run workflow in unix?

5 Answers   Colgate, HP, Tech Mahindra,


Which means the first record should come as last record and last record should come as first record and load into the target file?

0 Answers   Informatica,


my source is junk data how will u remove that junk data by using unix please any one replay me

0 Answers   Cap Gemini,


Why the workflow is failed after running two hours in informatica?

1 Answers   GE,


How mapping parameter and variable works

1 Answers  


Explain one complecated mapping?

3 Answers   Fidelity, Wipro,


Categories