13.3 Executing the Account Dimension SCD

Batch FSDFINFO_DATA_FOUNDATION_SCD has been introduced with 40 tasks under it.

These 40 tasks represent the 40 SCD processes where different product processors would be the source and DIM_ACCOUNT would be the target. MAP_REF_NUMs 188 to 217, 262 to 264, 341, 349 to

354, 400, 465, 467 have been introduced into SYS_TBL_MASTER table, and subsequently into SYS_STG_JOIN_MASTER.

Depending on the requirement by an application, a task can be excluded or included from the batch execution.

• SCD execution occurs based on the GAAP code which is configured in SETUP_MASTER table. This has been introduced to tackle the scenario of multiple GAAP codes. Whether or not there exist multiple GAAP codes, SETUP_MASTER should be manually configured as follows:
• All the tasks can be executed in parallel. This might cause the N_RCV_LEG_ACCT_SKEY to have an incremental value as compared to N_ACCT_SKEY.

  Note:

  By default, FSDF installer will seed the following entry into SETUP_MASTER.

Table 13-2 Configuration for the Account Dimension SCD GAAP Codes

V_COMPONENT_ CODE	V_COMPONENT_DESC	V_COMPONENT_VALUE
DEFAULT_GAAP	DEFAULT_GAAP	USGAAP

For all other GAAP codes, we need to update SETUP_MASTER manually before running DIM_ACCOUNT SCD.