What is the difference between join, merge, and lookup stages?

The quantity of memory required by these three steps is the primary distinction. Aside from that, how they handle the input required and the various records are other differentiating considerations. The lookup stage consumes relatively little memory in terms of memory utilization. The search and merging steps both consume a significant amount of memory.