How to load in a target table from a delimited file having more than one same value in a column. I have to take the distinct values of the column.
please help how can i do it?
nirmallyakoley, You can achieve this by using a tAggregateRow component in your job. tfiledelimitedinput --> tAggregateRow --> etc.. In the tAggregateRow add all your columns to the groupby and you will get the distinct results. Regards
