Identical column names in Lookup - Best practice

ds_is_fun · Post by **ds_is_fun** » Mon Oct 29, 2007 7:37 am

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!

ray.wurlod · Post by **ray.wurlod** » Mon Oct 29, 2007 7:51 am

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.