How to retrieve only distinct record from 'flatfile' source, without using sorter transformation? Is it posible? How?

sheeladere

 Profile Answers by sheeladere Questions by sheeladere

• Jan 5th, 2010

We can use Aggregate transformation for this. Group by on all the columns in the Aggregator and get only first or last record from the group, it will give you distinct records.But sorter is the best option, I am not sure why you want to avoid it, is there any specific reason?

jsrprasad0402

 Profile Answers by jsrprasad0402 Questions by jsrprasad0402

• Sep 22nd, 2009

Create a Variable port for all the input port and keep them in a seequence that the variable ports will access first after the input port. Then, compare the same variable ports in the ouput port along...

Answer Question  Select Best Answer