Yes, but there are other options. For example, a Lookup stage can perform a "sparse" lookup directly to a DB2 or Oracle table. Almost no impact on memory whatsoever. Ask yourself whether a lookup to a Lookup File Set loads a virtual Data Set first? If not, again little impact on memory.
That's another of the variables that would affect your decision.
Dataset, Fileset
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: