Thanks Devyanth , Sort transformation was helpful but now i have a question how should i build my data flow to capture duplicate records in a file and what are...

Can anyone give me a some idea to eliminate duplicate records without using sql functions and by only using transformations.