SUPPORT / SAMPLES & SAS NOTES
Problem Note 45920: The SCD Type 2 Loader transformation provides no option to suppress index creation on the permanent cross reference table or on the target table
 |  |  |  |  |
In SAS® Data Integration Studio, you cannot suppress the index creation in an SCD Type 2 Loader transformation on either the permanent cross reference table, or on the target table. The default behavior is to automatically create an index on both the permanent cross reference table and on the target table. However, in certain situations, you might want to be able to suppress this automatic index creation.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Installing the hot fix provides two new options to suppress automatic index creation:
- Create an index on the permanent cross reference table
- Create an index on the target table
The default value for both options is Yes. You must change the value to No to suppress automatic index creation.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Data Integration Studio | Windows Vista for x64 | 4.21 | 4.4 | 9.2 TS2M2 | 9.3 TS1M0 |
| Windows 7 Ultimate x64 | 4.21 | 4.4 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Windows 7 Ultimate 32 bit | 4.21 | 4.4 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Windows 7 Professional x64 | 4.21 | 4.4 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Windows 7 Professional 32 bit | 4.21 | 4.4 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Windows 7 Home Premium x64 | 4.21 | 4.4 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Windows 7 Home Premium 32 bit | 4.21 | 4.4 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Microsoft® Windows® for x64 | 4.21 | 4.4 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 4.21 | 4.4 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.21 | 4.4 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.21 | 4.4 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 for x64 | 4.21 | 4.4 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2008 | 4.21 | 4.4 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2008 for x64 | 4.21 | 4.4 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Microsoft Windows XP Professional | 4.21 | 4.4 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Windows Vista | 4.21 | 4.4 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Windows 7 Enterprise 32 bit | 4.21 | 4.4 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Windows 7 Enterprise x64 | 4.21 | 4.4 | 9.2 TS2M2 | 9.3 TS1M0 | ||