Hi All,
What would be an ideal condition for using sparse look up and when should we avoid the temtation of using it.
Ideal condition for using sparse Look up
Moderators: chulett, rschirm, roy
Ideal condition for using sparse Look up
Om Prakash
"There are things that are known, and there are things that are unknown, and in between there are doors"
"There are things that are known, and there are things that are unknown, and in between there are doors"
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
More precisely, your main input stream can contain very many rows too, but only a small number distinct lookup key values.
The idea of a sparse lookup is to be able to avoid loading a huge reference table into either a virtual Data Set or Lookup File Set.
The idea of a sparse lookup is to be able to avoid loading a huge reference table into either a virtual Data Set or Lookup File Set.
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.