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

Answer Posted / 9019

Sorter select distinct, aggregator group by columns

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why sorter is an active transformation?

758


What are the databases that informatica can connect to windows?

587


What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

4793


What's the layout of parameter file (what does a parameter file contain?)?

1919


How do you load alternate records into different tables through mapping flow?

1298






What are the different types of transformation available in informatica.

641


generate date / time dimension in informatica

727


How can a transformation be made reusable?

667


explan ur project architecture?

1599


What is informatica metadata and where is it stored?

592


Can anyone tell me the new features in Informatica 9 Version?

1534


What differs when we choose the sorted input for aggregator transformation?

576


How to elaborate tracing level?

689


What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

6422


What are different types of transformations available in informatica?

590