Performance wise,if you use apply map .the mapping table will be existed at the time of script execution only and using apply map it avoids duplicates it shows 1 to 1 connection.
but apply map is useful when we want look up to one field in destination table.
