LUTCreateOp and LUTProcessOp
February 25, 2018
DSxchange, every now and then, comes up with some very interesting discussions thanks to the DataStage gurus like Ray, Craig, Arnd et al. This post by Ray on the lookup composite operator was something I was looking for since a long time. Finally found it. Here’s what Ray Wurlod had to say:
Lookup stage ordinarily generates a composite operator consisting of LUTCreateOp and LUTProcessOp.
LUTCreateOp loads the reference data into memory and builds a hash index on the fly, unless the reference data are in a Lookup File Set in which case the index was built when the Lookup File Set was created/written to.
Posted in Technology