Page 1 of 1

Multiple Reference in Lookup

Posted: Sun Oct 15, 2006 9:22 am
by vijayrc
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 ??? :roll:
Any light on this is greatly appreciated. Thanks in advance. -V

Posted: Sun Oct 15, 2006 1:20 pm
by ray.wurlod
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.