Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


What if the source is a flat-file? Then how can we remove the duplicates from flat file source?



What if the source is a flat-file? Then how can we remove the duplicates from flat file source?..

Answer / 9019

Sorter select distinct, aggregator group by columns

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

What is the Rank index port in Rank transformation?

0 Answers   Informatica,


What is transformation?

0 Answers  


Explain sessions. Explain how batches are used to combine executions?

0 Answers  


What is checksum termnology in informatica? Where do you use it ?

3 Answers   Chase, Cognizant, Deloitte,


Can anyone briefly describe abt audit table loading?

2 Answers   TCS,






how many repositories can v create in informatica .

3 Answers   Cap Gemini, Tech Mahindra,


Write the program through which the records can be updated?

0 Answers  


i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?

9 Answers   Cap Gemini,


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,


i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica

5 Answers   Cap Gemini,


a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet having 65536 colums but flat files one lak columns). how to get one laks colums in excel sheet .

2 Answers   TCS,


How to jion 2 tables, without using any condition?

11 Answers   Amazon,


Categories