Load Append extracts all records from the source table and appends them to the existing records on the target table.
-
This process can result in duplicate records in the target data warehouse table.
-
The Key+ checkbox on the Design page has no impact on the operation of Load Append.
For more see the example in ETL+ Load Upsert Example 2
Pages in this Section
-
ETL+ Load Append Example 1 Example of a target table that results from a Load Append from a .csv source file.