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

my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?

10 Answers   Cap Gemini, Wipro,


what is the difference between onsite & client site?

1 Answers  


I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?

5 Answers   Syntel,


Explain informatica architecture - version 8 / 9

0 Answers   Informatica,


What is joiner cache?

2 Answers   TCS,






Can you create a flatfile target

3 Answers   ABC,


What is meant by LDAP users?

0 Answers  


What is diff between connected and unconnected lookup?

5 Answers   BirlaSoft, Blue Star Infotech,


What are the guidelines to be followed while using union transformation?

0 Answers   Informatica,


Make a note of the quantity vaults made in informatica?

0 Answers  


ename,deptcount vamshi,3 kumar,5 krish,8 in o/p i want vamshi record 3 times kumar record 5 times like wise what is the logic.? give the entire logic plz

1 Answers   IBM,


What is an active transformation?

0 Answers   Informatica,


Categories