Package Template: Load Rows Sequence

In the Load Rows sequence, standard tasks are Truncate Staging, Adding Staging Indices, Upsert, and Adding Indices. Staging tables in a Blackbaud Data Warehouse database hold data before loading into the proper BBDW tables. In this example Sequence, during Load Rows, the staging tables are truncated to remove existing data. Data from the OLTP database is loaded into the staging tables and then the staging tables are indexed. Data in the staging tables is then loaded into the proper BBDW database tables and then the proper tables are indexed.