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.