What Are The Different Strategies You Can Use To Avoid Duplicate Rows

1.	What Are The Different Strategies You Can Use To Avoid Duplicate Rows Of Data When Re-loading A Job.
Answer» Using the auto-correct load option in the target table. INCLUDING the Table COMPARISON transform in the DATA flow. Designing the data flow to completely replace the target table during each execution. Including a PRELOAD SQL statement to execute before the table loads.

What Are The Different Strategies You Can Use To Avoid Duplicate Rows Of Data When Re-loading A Job.

Answer»

Using the auto-correct load option in the target table.
INCLUDING the Table COMPARISON transform in the DATA flow.
Designing the data flow to completely replace the target table during each execution.
Including a PRELOAD SQL statement to execute before the table loads.