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 can u avoid duplicate rows in flat file?

Answers were Sorted based on User's Feedback



how can u avoid duplicate rows in flat file?..

Answer / sunil

In a sorter transformation select distinct option to avoid
duplicates in a flat file

Is This Answer Correct ?    11 Yes 0 No

how can u avoid duplicate rows in flat file?..

Answer / radhakrishnansk

sorted transformation

Is This Answer Correct ?    6 Yes 1 No

how can u avoid duplicate rows in flat file?..

Answer / ramanaiah

without using sorter,and aggregrator transformations.we can
useing dynamic lookup to avoid duplicate rows.

Is This Answer Correct ?    3 Yes 1 No

how can u avoid duplicate rows in flat file?..

Answer / sbvp

i also faced this question . i said that i am using sorter
and agg group by options. but they ask me again with out
using sorter and agg how can u eliminate the duplicates? so
, plz give me a answer for that

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

In which circumstances that informatica server creates Reject files?

2 Answers  


Hello...... How can i set my mapping as read-only? Please answer me. Advance thanks

4 Answers  


How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????

2 Answers   TCS,


Tell me how many tables used in Ur project and how many fact tables and dimension tables used in ur project

2 Answers   iGate, Qualcomm,


Is it possible to revert a global repository to local one and why?

0 Answers  


How to load the source table into flat file target(with columns) in informatica?

4 Answers   Accenture,


Using Expression transformation how to remove duplicate records from a relational source?

4 Answers  


Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

0 Answers  


AT the max how many transformations and mapplets can we use in a mapping ?

1 Answers   Cap Gemini, Cognizant,


How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

0 Answers  


define galaxy repository in informatica

0 Answers  


how we can add header and footer to flat files?

2 Answers   Tech Mahindra, Zensar,


Categories