When running the SAS Merchandise Data Integration mdi_loaddm_merch_cmast and mdi_loaddm_merch_hierarchy jobs, the program performs both of these tasks:

• downloads db_dictitionary for all table objects
• creates run-time SAS code for each table object that handles default and null values

Performing both tasks impacts the overall performance of the jobs.

In addition, the post-hierarchy load process executes reclass-related steps each time the load runs. The steps should run only during the reclass process (when UPDATE_HIERARCHY=Y). Running the additional steps impacts the overall performance of the hierarchy load.

To improve the performance issue, create run-time SAS code only for hierarchy-related table objects that handle default and null values. To address the post hierarchy load issue, add a validation to run the reclass-related steps only when UPDATE_HIERARCHY=Y. Contact SAS Technical Support to get replacement mdi_loaddm_merch_hierarchy.sas and mdi_loaddm_merch_cmast.sas files that address each issue.

To implement this solution, follow these steps.

1. Make a backup copy of the following files:
   $MDI_ROOT/code/sascode/mdi_loaddm_merch_hierarchy.sas
   $MDI_ROOT/code/sascode/mdi_loaddm_merch_cmast.sas

2. Save the replacement mdi_loaddm_merch_hierarchy.sas and mdi_loaddm_merch_cmast.sas files in $MDI_ROOT/code/sascode.