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...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

How to delete duplicate records in a flat file source?

Question Posted / laxman

Answers were Sorted based on User's Feedback



How to delete duplicate records in a flat file source?..

Answer / bsgsr

conncet the flat file to sorter transformation and select
distinct option.

Is This Answer Correct ?    17 Yes 6 No

How to delete duplicate records in a flat file source?..

Answer / sushanth1234

Connect the flat file to sorter tx and make ascending and connect from sorter to aggregator
tx make group by port and one o/p port count(port) after use router tx 2 group 1)count<0 and 2)count=0 transfer to target for both group Unique and dublicate.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

Performance wise which is better joiner or look up ? Give me with example?

1 Answers   CGI,

While importing the relational source definition from the database, what are the metadata of source that will be imported?

0 Answers   Informatica,

8.what is mapplet ?give example?

2 Answers  

what is data driven?

5 Answers   TCS, Wipro,

Which is better performance wise database or file?How?

2 Answers   TCS,

wf dont have integration severances how you can run?

0 Answers   TCS,

what is constraint based load order

2 Answers   Cap Gemini,

error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.

4 Answers  

How to identify this row for insert and this row for update in dynamic lookup cache

3 Answers   CSC,

What are the connected or unconnected transforamations?

2 Answers  

We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?

3 Answers  

Write the prerequisite tasks to achieve the session partition?

0 Answers  

For more Informatica Interview Questions Click Here
Categories