5.2 Simple Dimension Loader

Note:

Currently the dimension loader program works only for key dimensions.

Simple Dimension Loader provides the ability to load data from stage tables to Simple dimension tables.

For example, the user can load data into FSI_ACCOUNT_OFFICER_CD and FSI_ACCOUNT_OFFICER_MLS using the Simple Dimension Loader program.

Simple dimension of type 'writable and editable' can use this loading approach. This can be identified by querying

rev_dimensions_b.write_flag = 'Y', rev_dimensions_b.dimension_editable_flag ='Y' and rev_dimensions_b.simple_dimension_flag = 'Y'.

Topics:

• Creating Simple Dimension Stage Table
• Configuration of Setup Tables
• Executing the Simple Dimension Load Procedure
• Exception Messages