sathya

• Jun 27th, 2006

 

We can eliminate the duplicate rows by checking the distinct option in the properties of the transformation.

neelesh

• Jul 4th, 2006

 

U can use SQL query for uniqness if the source is Relational

But if the source is Flat file then u should use Shorter or Aggregatot transformation

joe

• Jul 4th, 2006

 

use source qualifier transformation to eleminate duplicate rows

Sravan

• Sep 14th, 2006

 

If we use source qualifier then its good .Also improoves the perfermence

lakshmi1

 Profile Answers by lakshmi1 Questions by lakshmi1

• Sep 15th, 2006

 

Hi

You dont need both filter and router to eliminate duplicate rows. One of them should be sufficient. However, use Source Qualifier for better performance.