Hi All,
one of my Job with Lookup having Reference Link Seqential file Stage
this is possible? if possible then what is the use of Lookup File Set Stage?
help me....
KKSR
Lookup file Set
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
A Lookup File Set includes an internal index on the key columns.
A Sequential File stage would need to be completely imported into a virtual Data Set, but this lacks an index, so that lookups would still require a partial or full scan.
A Sequential File stage would need to be completely imported into a virtual Data Set, but this lacks an index, so that lookups would still require a partial or full scan.
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.