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

have you developed documents in your project? and what documents we develop in realtime?

2 Answers   IBM,


whatis the default data driven operation in informatica

2 Answers  


How do you handle decimal places while importing a flatfile into informatica?

1 Answers  


How to send duplicates to one target and unique rows to one target?target is empty

9 Answers   Amazon, IBM, Wipro,


If you have 10 mappings designed and you need to implement some chages (may be in existing mapping or new mapping need to be designed) then how much time it takes from easier to complex?

1 Answers  


Explain what are the different versions of informatica?

0 Answers  


Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

8 Answers   HP,


how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)

2 Answers   Sonata,


What are the designer tools for creating tranformations?

1 Answers   Informatica,


When the informatica server marks that a batch is failed?

2 Answers  


How we can confirm all mappings in the repository simultaneously?

1 Answers  


what is the main advantage of unconnected lookup

2 Answers   Cap Gemini,


Categories