choose distinct records from Relational sources. Next we asked the question, how may we select the distinct records for Flat File sources?
Here since the source system is a Flat File you will not be able to select the distinct option in the source qualifier as it will be disabled due to flat file source table. Hence the next approach may be we use a Sorter Transformation and check the Distinct option. When we select the distinct option all the columns will the selected as keys, in ascending order by default.
No comments:
Post a Comment