Driver records load

Integration table data is loaded to the WDCDRIVER cube.

Customer data must be loaded to the DAT_WDCDRIVER_STAGE table from where the depm_integration_wp_driver_prepare_staging.sql script does the data validation and loads to the DAT_WDCDRIVER_TRANSFORMED table. The validation checks if each dimension value exists in the associated dimension table. All driver dimension tables, _ELEMENTS and _PARENTS, must be updated.

If an element does not exist in the dimension table, an error is shown in the TRANSFORMED driver table for that dimension and record.

Validation also checks that the element length cannot exceed the set max length. If it exceeds the maximum length, an error is shown.

The depm_integration_wp_driver.sql script warns for the errors and if there are any, stops the process and asks for data correction.

If no errors are found, the script loads the data to the ATT_ WDCDRIVER table. The data can be loaded to the OLAP database from this table.