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 do you mean by filter transformation?

1 Answers  


source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

1 Answers   Cap Gemini, Cognizant,


Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?

1 Answers   Wipro,


How many mapplets u have created? and what is the logic used

5 Answers   Mind Tree,


In operator is used in which transformation in informatica 8.6.0

5 Answers   Virtusa,


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,


HOW DO YOU PARFORM INCREMENTAL LAOD ?

7 Answers   SAIC,


What is staging area?

11 Answers  


where to select code page option?

2 Answers   TCS,


SOURCE NAME SAL GANGA 30000 RAJU 20000 PAVAN 25000 TARGET NAME SAL MAXSAL GANGA 30000 30000 RAJU 20000 30000 PAVAN 25000 30000 in mapping level how to achive that

5 Answers   DELL,


Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.

5 Answers   DELL, TCS,


What are multi-group transformations?

1 Answers   Informatica,


Categories