IKM control Append

In the Append strategy, flow data is simply inserted in the target table without any flow control. This approach can be improved by adding extra steps that will store the flow data in an integration table ("I$"), then call the CKM to isolate erroneous records in the error table ("E$").

This integration strategy includes the following steps:

1. Drop (if it exists) and create the integration table in the staging area. This is created with the same columns as the target table so that it can be passed to the CKM for flow control.
2. Insert data in the loading table from the sources and loading tables using a single INSERT/SELECT statement similar to the one loading the target in the append strategy.
3. Call the CKM for flow control. The CKM will evaluate every constraint defined for the target table on the integration table data. It will create an error table and insert the erroneous records into this table. It will also remove erroneous records from the integration table.

a.      After the CKM completes, the integration table will only contain valid records. Inserting them in the target table can then be done safely.

4. Remove all records from the target table. This step can be made dependent on an option value set by the designer of the interface
5. Append the records from the integration table to the target table in a single INSERT/SELECT statement.
6. Commit the transaction.
7. Drop the temporary integration table.