Manisha

• Jul 17th, 2006

 

You can add an aggregator before insert and group by the feilds that need to be distinct.

abc

• Jul 26th, 2006

 

IN the source qualifier write the query with distinct on key column 

MOHAN REDDY

• Aug 27th, 2006

 

Well

There are two methods to get distinct values:

If the sources are databases then we can go for SQL-override in source qualifier by changing the default SQL query. I mean selecting the check box called [] select distinct.

and

if the sources are heterogeneous, i mean from different file systems, then we can use SORTER Transformation and in transformation properties select the check box called [] select distinct same as in source qualifier, we can get distinct values.