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
Multiple Reference in Lookup
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.