Remove duplicate rows from flat file

How can we remove duplicate rows from the flat file?

E

Expert

Verified

Use Sorter Transformation. When we configure Sorter Transformation to treat the output rows as distinct, it configures overall ports as part of sort key. It thus abandons duplicate rows compared through the sort function.

   Related Questions in Database Management System

©TutorsGlobe All rights reserved 2022-2023.