Customize the integration data load

The stored procedures are written to be used within the Base Data Store integration user interface but they are adaptable to different requirements and environments.

Not all implementations require all the component areas to be imported. For flexibility, the processing is split into separate stored procedures, usually separated by dimension.

Stored procedures are run to accomplish the specific dimension and cube data preparation tasks within the component area. Portions of these stored procedures can also be disabled or enabled as needed. There is a required sequence in some areas. For example, structure information for one area must have been completed successfully, without error records, before another can begin.