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

sample mappings for scd1,scd2 and scd3

2 Answers   Cognizant,


What are the settings that you use to configure the joiner transformation?

0 Answers   Informatica,


Explain the types of lookup transformation?

0 Answers  


What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

0 Answers  


while creating the scd mappings. we will mention flag value. what exactly the use of defining the FLAG VALUE. Please explaine indetaile

2 Answers   Amdocs,


What are the different components of powercenter?

0 Answers  


why cant we put a sequence generator or upd strategy transformation before joiner transformation?

2 Answers   Satyam,


get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c

3 Answers   Infosys,


What are the types of caches in lookup?

0 Answers  


How do you update the records with or without using update strategy?

0 Answers  


I've an excel sheet, in which one column contains data about the location like "City, State" and few columns contains only "State". Now I wanna load into my target City and State into two different columns. Pls help me out...

6 Answers   TCS,


What is IQD file?

1 Answers  


Categories