ETL jobs use staging tables (that is, predefined interface tables) to transform raw order data and prepare it for upload to Incent. Before we start a new upload, we need to purge the old data from those tables.

Purge Previous Orders

 

The standard interface table that stores information about sales orders and transactions is staging.order_item.

 

Delete the old data from staging.order_item:

 

1 SQL> delete from staging.order_item;

 

Purge Previous Order Assignments

 

The standard interface table that stores the employee assignments that are used in Incent crediting rules is staging.order_item_assignment.

 

Delete the old data from staging.order_item_assignment:

 

1 SQL> delete from staging.order_item_assignment;

 

Purge Previous Validation Fails

 

The standard interface table that stores validation errors is staging.order_item_validation_error. It stores information for rows that fail any validations against staging.order_item and staging.order_item_assignment.

 

Delete the old data from staging.order_item_validation_error:

 

1 SQL> delete from staging.order_item_validation_error;