Problem Note 20740: The target table is generated with incorrect data when lookup table
column names match source table column names
If the following scenario occurs when you use a Lookup transformation,
SAS® Data Integration Studio generates the target table with incorrect
data values:
Scenario
The Mapping tab under Lookup properties references a column in the
source table:
Lookup Properties
Mapping
Source Table Target Table
---------------------------
AccountID -> Account
A lookup table column name matches a source table column name that is
being referenced in the Mapping tab. This column name is also referenced
in the Source to Lookup Mapping tab within a lookup definition under
Lookup properties - Lookups. For example:
Lookup Properties
Lookups
Source to Lookup Mapping
Source Table Lookup Table
---------------------------
GL_Account -> AccountID
When this scenario occurs, the target table column is populated with
data values from the source table column defined under the Source to
Lookup Mappings tab instead of from the source table column defined
under the Mappings tab.
In the example outlined above, the Account column in the target table is
populated with data values from the source table's GL_Account column
instead of the data values from the AccountID column.
You can avoid this issue by using unique names for the lookup table
columns and the source table columns. To accomplish this, insert a step
prior to the Lookup and map conflicting columns to new names.
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| SAS System | SAS Data Integration Studio | Microsoft Windows XP Professional | 3.3 | | 9.1 TS1M3 SP3 | |
| Microsoft Windows NT Workstation | 3.3 | | 9.1 TS1M3 SP3 | |
| Microsoft Windows Server 2003 Standard Edition | 3.3 | | 9.1 TS1M3 SP3 | |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 3.3 | | 9.1 TS1M3 SP3 | |
| Microsoft Windows Server 2003 Enterprise Edition | 3.3 | | 9.1 TS1M3 SP3 | |
| Microsoft Windows Server 2003 Datacenter Edition | 3.3 | | 9.1 TS1M3 SP3 | |
| Microsoft Windows 2000 Professional | 3.3 | | 9.1 TS1M3 SP3 | |
| Microsoft Windows 2000 Server | 3.3 | | 9.1 TS1M3 SP3 | |
| Microsoft Windows 2000 Advanced Server | 3.3 | | 9.1 TS1M3 SP3 | |
| Microsoft Windows 2000 Datacenter Server | 3.3 | | 9.1 TS1M3 SP3 | |
*
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.
| Type: | Problem Note |
| Priority: | alert |
| Date Modified: | 2007-08-21 14:35:08 |
| Date Created: | 2007-08-02 21:29:10 |
