About Dimension Loading Process

This chapter provides information about Dimension Loading Process in the Data Foundation application.

This chapter includes the following topics:

·        About the SCD Component

§        Type 1 SCDs - Overwriting

§        Type 2 SCDs - Creating another Dimension Record

§        Type 3 SCDs - Creating a Current Value Field

·        Populating Data in Dimension Table

§        Prerequisites

§        Tables Used by the SCD Component

§        Loading Dimension Tables 

§        Seeded Data 

§        Loading Policy Tables through Insurance SCD

§        Loading Dimension Tables through SCD

§        Loading Key Dimensions using AMHM and Hierarchy Flattening

§        Loading Data from STG_INTF Tables to DIM_INTF Tables

§        Executing the Loading Procedure using Batch Framework

§        Executing The Hierarchy Flattening Procedure using Batch Framework 

§        Checking the SCD Batch Execution Status

·        Supplementary Information for Dimension Loading Process

§        Improving SCD Performance 

§        Handling Multiple GAAP Codes for the Same Account Number for the Same MIS Date in SCD

§        Handling Multiple GAAP Codes for the Same Account Number for the Same MIS Date in the Function