Load data into data mart

The load management process in Business Intelligence is illustrated here:

Load Management
  1. Back up the OLTP source database before you go live (typically two weeks earlier) with Business Intelligence.
  2. Initial data load from the backup database to the Data mart Database
  3. Incremental data load from the Sterling Source Database to the Data mart Database
Note: Business Intelligence does not provide a staging database, however, if you have deployed a sharded environment, it is recommended that you create a staging database to consolidate the data.