All three terms are different in terms of memory storage, input requirements, how they treat the records. Lookup stage needs high memory when compared to Merge and Join.