Join execution using a Map join operator even though the small table doesn't fit in memory as spilling some data from the build and probe sides will still be cheaper than having to shuffle the large fact table

The design was based on Hadoop’s parallel processing capability and significant amount of memory available.