Employee FTE records load
Data from the integration tables is loaded to the WDCCALCULATION cube.
Source data must be loaded to the DAT_WDCCALCULATION_STAGE table. This is
where the depm_integration_wp_calculation_prepare_staging.sql
script does the data
validation and loads the data to DAT_WDCCALCULATION_TRANSFORMED. Validation checks if each
dimension value exists in the associated dimension table. All calculation dimension tables,
_ELEMENTS and _PARENTS, are updated.
If an element does not exist in the dimension table, an error is shown in the TRANSFORMED calculation table for that dimension and record.
Validation also checks that the element length cannot exceed the set maximum length. If it exceeds the maximum length, an error is shown.
The depm_integration_wp_calculation.sql
script warns about any errors and stops the
process.
If no errors are found, the script loads the data to the ATT_WDCCALCULATION table from where data can be loaded to the OLAP database.