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.