Page 1 of 1
what is the difference between lookup,merge,and join stage?
Posted: Fri Jan 30, 2009 12:33 am
by arun@sinmax
what is the difference between lookup,merge,and join stage?
Posted: Fri Jan 30, 2009 12:59 am
by ray.wurlod
Moderator: please move to parallel forum
Did you bother to
Search (this question has been asked and answered before) or to read the relevant chapters (one for each stage type) in the
Parallel Job Developer's Guide?
Posted: Fri Jan 30, 2009 2:04 am
by fareeda_b
Hi arun,
The Lookup stage is most appropriate when reference data is small enough to fit into physical (shared) memory.
Limit use of Sparse Lookup(for DB2 and Oracle reference tables)
For reference datasets larger than available memory, use the JOIN or MERGE stage.
thanks
fareeda
Posted: Fri Jan 30, 2009 12:08 pm
by kduke
fareeda
We tend not answer questions which may look like a job interview question.