Problem Note 70970: Incorrect results can be generated with the Lookup Transformation when a column in a source table is renamed
 |  |  |  |  |
Incorrect results for Lookup transformations can be generated when columns with the same name exist in both source and dimension tables.
The problem can occur when values for columns with the same name are needed in the fact table that is generated by the transformation. You must rename the column in either the source or dimension table to output both values to the fact table. Incorrect results can be generated when you rename the column in the source table. The new column that is written to the fact table contains the value from the dimension table.
A workaround is to rename the column in the dimension table.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Data Integration Studio | Microsoft® Windows® for x64 | 4.905 | 9.4 TS1M7 | ||
| Microsoft Windows 8 Enterprise 32-bit | 4.905 | 9.4 TS1M7 | ||||
| Microsoft Windows 8 Enterprise x64 | 4.905 | 9.4 TS1M7 | ||||
| Microsoft Windows 8 Pro 32-bit | 4.905 | 9.4 TS1M7 | ||||
| Microsoft Windows 8 Pro x64 | 4.905 | 9.4 TS1M7 | ||||
| Microsoft Windows 8.1 Enterprise 32-bit | 4.905 | 9.4 TS1M7 | ||||
| Microsoft Windows 8.1 Enterprise x64 | 4.905 | 9.4 TS1M7 | ||||
| Microsoft Windows 8.1 Pro 32-bit | 4.905 | 9.4 TS1M7 | ||||
| Microsoft Windows 8.1 Pro x64 | 4.905 | 9.4 TS1M7 | ||||
| Microsoft Windows 10 | 4.905 | 9.4 TS1M7 | ||||
| Microsoft Windows 11 | 4.905 | 9.4 TS1M7 | ||||
| Microsoft Windows Server 2008 | 4.905 | 9.4 TS1M7 | ||||
| Microsoft Windows Server 2008 R2 | 4.905 | 9.4 TS1M7 | ||||
| Microsoft Windows Server 2008 for x64 | 4.905 | 9.4 TS1M7 | ||||
| Microsoft Windows Server 2012 Datacenter | 4.905 | 9.4 TS1M7 | ||||
| Microsoft Windows Server 2012 R2 Datacenter | 4.905 | 9.4 TS1M7 | ||||
| Microsoft Windows Server 2012 R2 Std | 4.905 | 9.4 TS1M7 | ||||
| Microsoft Windows Server 2012 Std | 4.905 | 9.4 TS1M7 | ||||
| Microsoft Windows Server 2016 | 4.905 | 9.4 TS1M7 | ||||
| Microsoft Windows Server 2019 | 4.905 | 9.4 TS1M7 | ||||
| Microsoft Windows Server 2022 | 4.905 | 9.4 TS1M7 | ||||
| Windows 7 Enterprise 32 bit | 4.905 | 9.4 TS1M7 | ||||
| Windows 7 Enterprise x64 | 4.905 | 9.4 TS1M7 | ||||
| Windows 7 Home Premium 32 bit | 4.905 | 9.4 TS1M7 | ||||
| Windows 7 Home Premium x64 | 4.905 | 9.4 TS1M7 | ||||
| Windows 7 Professional 32 bit | 4.905 | 9.4 TS1M7 | ||||
| Windows 7 Professional x64 | 4.905 | 9.4 TS1M7 | ||||
| Windows 7 Ultimate 32 bit | 4.905 | 9.4 TS1M7 | ||||
| Windows 7 Ultimate x64 | 4.905 | 9.4 TS1M7 | ||||
A fix for this issue for SAS Middle Tier 9.4_M8 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/M2K.html#70970A fix for this issue for Data Integration Studio 4.7_M8 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/M5A.html#70970A fix for this issue for SAS Management Console 9.4_M7 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/I9E.html#70970A fix for this issue for SAS Middle Tier 9.4_M7 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/J2L.html#70970A fix for this issue for Data Integration Studio 4.7_M7 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/J7S.html#70970| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2024-10-24 10:04:57 |
| Date Created: | 2024-09-19 13:39:56 |