remove duplicate values in a source using Informatica

[narasimha.e]

How to remove duplicate values in a source using Informatica?
Which transformations to use?
what is the query?

NOTE : [This question was asked by dharma]

if soure is relational then we can used source qualifier transformation,
if source is flat file then we can used joiner (by using option sort) or by using Aggregator (by using Group by port) or look up Transformation.


Narasimha Reddy