-
A model has the Copy Request Properties with Error Mode set to Skip Record and Target Apply mode set to Delete on target, refresh.
A copy request has 2 tables set to copy, where the first table has 1 million rows and the target is similar. If the first table has errors on 100,000 rows, the resultant target table will have 900,000 rows.
-
A model has the Copy Request Properties with Error Mode set to Skip to next table and Target Apply mode set to Delete on target, refresh.
A copy request that has 2 tables set to copy, has 1 million rows and the target is similar. If the first table has 1 million rows with errors on 100,000 rows, The number of rows in the tables will depend on when the first error is encountered. When a Delete target, refresh copy request starts, it truncates the table or deletes the target tables, depending on the target DBMS. Regardless of whether it truncates the table or deletes the target table, all of the target tables are empty before the first row is copied. In the first case, the first table could have as few a zero rows or as many as 900,000 depending on when the error is encountered. The second table, assuming no errors, would receive all the rows from the source.