Load data into data mart

The load management process in Sterling Business Intelligence is illustrated here:

Load Management
  1. Back up the OLTP source database before you go live (typically two weeks earlier) with Sterling 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: Sterling Business Intelligence does not provide a staging database, however, if you have deployed a multischema or sharded environment, it is recommended that you create a staging database to consolidate the data.