Edit the Load Schedule
Use this page to load changed data continuously into the data mart, to load all the data, or to load only the changed partitions.
- Locking level
- The locking level is disabled when you load data continuously.
- The Locking level protects the data against changes
during the load operation to ensure data consistency.
- NONE: No locking. The data is read from the different tables without locking them. Other user sessions can change the data during the load operation. As a result, the loaded data might be inconsistent. Data inconsistencies might be acceptable if the purpose of the data mart is to create statistics and discover trends, rather than to find the exact values of specific data rows.
- TABLE: Protects only the table that is being loaded against changes. Each table is locked in share mode while it loads with data. The loaded data is consistent within each table, but not necessarily across different tables.
- MART: Protects all the tables that are referenced by the data mart against changes during the load operation. All the tables are locked in share mode until the data mart is loaded. The loaded data is consistent from all of the tables. All of the other user sessions are blocked from changing the data in the tables that are loading.
- Load the data continuously
- Load the changed data in the fact tables at the interval that you specify in the Buffer time setting. To use this option, you must load the data mart one time. To load the data mart, select . A loaded data mart is in the Active state. If a table is added or dropped from the database server, you must drop and re-create the data mart to update the data mart. When you choose this option, you can also schedule a start time and the days of the week to load the data continuously.
- Schedule
- Load all the data
- Select the start time and the days of the week to load all the data.
- Load only the changed partitions
- Select the start time, stop time, and frequency to load the partitions that have changed since the last load. The partitions can be in fact tables or dimension tables. The schedule applies to every day of the week. If a table is added or dropped from the database server, you must drop and re-create the data mart to update the data mart. To use this option, you must load the data mart one time. To load the data mart, select . A loaded data mart is in the Active state. This option is disabled if you select Load the data continuously.