Raunak Mali

• Apr 3rd, 2012

 

1.If you think that duplicate records may be inserted to the target table.

Then first while inserting the data into the target table ignore it.

And then use "Select Distinct into" method on the target table and and add distinct data to new table.

And then drop the original target table and rename new table as target table.

selva

• Oct 8th, 2013

 

Target table select Yes to use auto correct loading. Auto correct loading ensures that the same row is not duplicated in a target table

Prasanna

• May 5th, 2014

 

Use Table comparison Transform ,find out the difference and load into the target table.