Datawarehouse synchronization
Use this function to update a datawarehouse from the data of a live folder. This synchronization can be defined:
- on a list of tables (the tables are checked and ranges are defined if necessary);
- for all the datawarehouse;
- only for the tables updated in an incremental fashion (only the new lines or the updated lines are regenerated).
In the case of non-incremental updates, it is possible to previously delete all the existing data in the updated tables. It is used to distribute a given situation on the live environment.
Prerequisite
Refer to documentation Implementation
Screen management
Entry screen
In addition to the entry of datawarehouse to synchronize, the different technical parameters of the synchronization are defined in this tab.
Data warehouse
| Code (field CODDOS) |
|
Use this check box to define the list of datawarehouses to be processed. |
Options
| Preliminary purge (field GEN) |
|
The datawarehouse synchronization function retrieves the data in the source tables and transfers them to the destination tables. Select this check box to reset the destination tables to zero and populate them again. |
| Detailed log file (field DET) |
|
Select this check box to generate a detailed log of the audit records that have been added to, modified or deleted in the fact and dimension tables. |
| Simulation (field SIMU) |
|
When this check box is selected, the synchronization is not performed, but only simulated. A log file is generated listing the tables that would have been updated if the operation was actually run. |
| Audit backup (field EPUAUD) |
|
Select this check box to retain the records of the audit table. This will allow you to reuse these records for another datawarehouse, for example. |
BI table selection
| field TYPVAL |
|
Select the List check box to only select the types of BI tables that you need. |
Grid BI table type
| Type (field TYPDES) |
| To process (field TYPSEL) |
| from (field TYPSTR) |
| To (field TYPEND) |