Answer Detail: RE: Under what circumstances join should be used inste...

GeekInterview.com > Interview Questions > Data Warehousing > Abinitio

Print |

Question: Under what circumstances join should be used instead on lookup.

November 11, 2007 07:37:10	#3
anji_abinitio	Member Since: Visitor Total Comments: N/A
RE: Under what circumstances join should be used inste...
In the case of the join, the memory issue can be addressed by changing the maxcore limit, which, if exceeded, is handled by writing files to disk. While this may be costly, it makes graph fairly robust. In case of lookup, if the memory exceeded, the graph fails due to lack of swap space.