Load management

Load management extracts, transforms, and loads (ETL) data from the online transaction processing (OLTP) database and other data sources into your data warehouse. Load management synchronizes the source model and target model to the warehouse model and updates the data mart to reflect the changes in the warehouse model. Load management also publishes the source and target packages to the IBM® Cognos® portal. You can use load management differently, depending on the environment that you work in.

Note: The ETL process cannot not load some data into the data mart when the system time of the IBM Cognos Analytics server is ahead of the OLTP database server. Before starting the ETL process, you must ensure that the time in the Analytics Server is set to at least 1 minute slower than the OLTP database server. If the system considerations do not allow for time synchronization, the Analytics server must run 1 minute slower than the OLTP server.