Hi
If it is a relational file u can select SELECT DISTINCT option in the source qualifier itself and can use filter transformation and specify the condition.