technical reason i dont know if its documented anywhere. but my understanding is that because its a lookup during your load of your initial table. e.g.
in case of join you have to load table1 into memory, load table 2 into memory and then the join is performed
for applymap load table2 into a map, table 1 into memory (with applymap performed during that load).
Small datasets you may not see much difference but for bigger datasets you will definitely see the difference
technical reason i dont know if its documented anywhere. but my understanding is that because its a lookup during your load of your initial table. e.g.
in case of join you have to load table1 into memory, load table 2 into memory and then the join is performed
for applymap load table2 into a map, table 1 into memory (with applymap performed during that load).
Small datasets you may not see much difference but for bigger datasets you will definitely see the difference
