Page 1 of 1

Identical column names in Lookup - Best practice

Posted: Mon Oct 29, 2007 7:37 am
by ds_is_fun
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!

Posted: Mon Oct 29, 2007 7:51 am
by ray.wurlod
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.