I have a job with two column names ename - table1, ENAME- table 2.
They both have the same length. Is it necessary to convert the names. Im assuming that as long as the types and lengths are sames we can perform a lookup between two columns.
Thanks!
Identical column names in Lookup - Best practice
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I assume you're talking about a Lookup stage here.
What you say is true except if the reference input is fed by a Lookup File Set or by a sparse lookup. In either of these cases the column name must be identical. The data type, of course, should always match or at least be compatible.
What you say is true except if the reference input is fed by a Lookup File Set or by a sparse lookup. In either of these cases the column name must be identical. The data type, of course, should always match or at least be compatible.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.