Dimension Data Loader

The Dimension Loader is used to load the dimension data from the File to Stage tables. The Dimension Loader procedure populates Dimension Members, Attributes, and Hierarchies from Staging Dimension Tables into the Dimension Tables registered with OFS CCA CS. You can view the Members and Hierarchies loaded by the Dimension Loader through the OFS CCA CS Screens.

The Data File Specification is not applicable to Dimension Data Loaders. The file format and the file names are static in nature.

The Dimension Loader is used to:

• Load the Dimension Members and their Attributes from the Staging area into the Dimension Tables that are registered with OFS CCA CS framework.
• Create Hierarchies in OFS CCA CS.
• Load Hierarchical relationships between Members within the Hierarchies from the Staging area into OFS CCA CS.

The following are the features of Dimension Loader:

• Multiple Hierarchies can be loaded from Staging Tables.
• Validations of Members and Hierarchies are similar to that of being performed within the OFS CCA CS Screens.

Before you start the Dimension Loader, you must upload the Data Files that have the Dimension details. The following is a list of sample files that you can use to build the Dimension Data. The name of the Data Files must be same as mentioned below and the File Extension must be .DAT. The following Sample Data Files are available on MOS.

Stage Dimension Loaders (Task 1):

• input_stg_dimensions_attr_intf.dat
• input_stg_dimensions_b_intf.dat
• input_stg_dimensions_tl_intf.dat
• input_stg_dimensions_hier_intf.dat

Stage Hierarchy Loaders (Task 2):

• input_stg_hierarchies_intf.dat
• input_stg_hierarchy_levels_intf.dat

To load the Dimensions, perform the following steps:

1. Define a new Batch and save it.
2. Add the following Tasks to the above Batch:

   Note:

   For more information, refer to the preseeded Dimension Loader Batches in the Reference Guide on MOS.

   Table 5-2 Dimension Loading Process Tasks

   Task Code	Task Name	Component	Parent Task
   1	Stage Dimension Loader	Stage Dimension Loader
   2	Stage Hierarchy Loader	Stage Hierarchy Loader	1
   3	Stage DRM Loader	Stage DRM Loader	2

   Note:

   The above Tasks must be executed in the same order.

   The Stage DRM Loader allows you to select a Dimension. You can select both Simple and Key Dimensions.

3. Execute the Batch.

For detailed instructions on Creating a Batch, Defining a Task, Execute the Task, and Schedule a Batch, see Scheduler Services.