3.2.2.1.2 For Simple Dimensions

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. Click on each Data File Name to open a Sample Data File.

Stage Dimension Loaders (Task 1):

• input_stg_dimensions_b_intf.dat
• input_stg_dimensions_tl_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:

   Table 3-4 Dimension Loading Process Tasks

   Task Code	Task Name	Component	Parameters	Parent Task
   1	Stage Dimension Loader	Stage Dimension Loader	All parameters are automatically generated.
   2	Stage DRM Loader	Stage DRM Loader	Dimension Name: Select the relevant one or more dimensions. Sync Stage and Dimension: Yes: The record(s) that is/are already present will be overwritten by the incoming dimension loader. No: The new records will be merged to the existing records. Force Member Delete: This is used only when the above flag is Yes. Yes: This allows you to delete a members even if is referred in hierarchies. No: No records will be deleted.	1

   Note:

   The above Tasks must be executed in the same order.

   The Stage DRM Loader allows you to select a Dimension.

3. Execute the Batch.

Dimension Loader with ZIP File Support

You can zip all the DAT files into a single file and upload it to the Object Store.

To process the zip file:

• Create a Batch.
• Create a Task with the Component Name as Dimension and Hierarchy Loader.
• Execute the Batch.

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