Multiple Reference in Lookup

vijayrc · Post by **vijayrc** » Sun Oct 15, 2006 9:22 am

Hi
Just read that a Lookup can have multiple references for an incoming stream of data to be matched.
My question [might sound silly]:
[1] Should the key to the Incoming data and all the reference be the same [in cases, where references are from multiple sources] ?? OR
[2] for each Reference can there be a different key to the incoming data to be matched ???

Any light on this is greatly appreciated. Thanks in advance. -V

ray.wurlod · Post by **ray.wurlod** » Sun Oct 15, 2006 1:20 pm

The lookup keys can be different for each reference input link. However, when there is no ability to specify a Key expression (such as when there is a Lookup File Set feeding the reference input link) then a column that is identically named and typed as the key column must occur in the stream input metadata.