Monday, 22 October 2012

What are the different strategies you can use to avoid duplicate rows of data when re-loading a job.

=>    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.

No comments: