When running a SAS Merchandise Data Integration dimension load job, the program downloads main data sets (such as LV10MAST, LV10CAT, and LV10MERCH), and copies them. The copies are named in the form XXXX_OLD, where XXXX is the name of the main data set. However, in the dm_compare macro, instead of using the existing XXXX_OLD data sets, the process again downloads the main data sets from the database. Downloading again results in additional download time and slows the load process.

To address this issue, modify the dm_compare macro to download the main data set only when the corresponding XXXX_OLD data set does not exist. Contact SAS Technical Support to get a replacement dm_compare.sas file that contains the modification.

To implement the modification, follow these steps:

1. Make a backup copy of $MDI_ROOT/code/sasmacro/dm_compare.sas
2. Save the replacement dm_compare.sas file in $MDI_ROOT/code/sasmacro.

A fix for this issue is planned for a future software release.

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
SAS System	SAS Merchandise Data Integration	64-bit Enabled AIX	6.1.3 M6	6.4	9.1 TS1M3 SP4	9.4 TS1M0
		64-bit Enabled Solaris	6.1.3 M6	6.4	9.1 TS1M3 SP4	9.4 TS1M0

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

---

duplicate download of main data sets

Type:	Problem Note
Priority:	high

Date Modified:	2013-10-29 16:26:11
Date Created:	2013-05-03 16:08:22