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 we eliminate duplicate rows from flatfile,explain?

Answers were Sorted based on User's Feedback



How can we eliminate duplicate rows from flatfile,explain?..

Answer / nagaraj.g

using sorter transformation for distinct in a flat files

Is This Answer Correct ?    16 Yes 0 No

How can we eliminate duplicate rows from flatfile,explain?..

Answer / veera reddy

By Using Aggregator transformation by selcting the group by
option or using sorter by using distinct option or by using
dynamic lookup by selecting distinct option.

Is This Answer Correct ?    6 Yes 5 No

How can we eliminate duplicate rows from flatfile,explain?..

Answer / seshagiri

veere reddy,

Dynamic lookup will not work for flat file only static
lookup will work for a flat file

Is This Answer Correct ?    2 Yes 3 No

Post New Answer

More Informatica Interview Questions

what are the difference between Informatica 7.1 and 8.1?

6 Answers  


how can i invoke pmcmd in command line prompt

1 Answers  


Explain the informatica workflow?

0 Answers  


After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can you map these three ports directly to target?

6 Answers  


suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how

4 Answers   CTS,


What is different between the data warehouse and data mart?

0 Answers  


what is song in infrmatica...?

0 Answers   CTS,


explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???

8 Answers   CTS, TCS,


What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?

2 Answers  


What do you understand by a term domain?

0 Answers  


in what type of scenario bulk loading and normal loading we use?

2 Answers   Cognizant, Wipro,


What are the differences between source qualifier and joiner transformation?

0 Answers  


Categories