Mahesh,
Take care, to use ApplyMap, you have done a Mapping load before : it will create a TEMP table with two fields : key, value. This table is used for lookup purposes and therefore replace a key with a value, for example a Customer with a price discount in%, a product id with a product desc, a product id with a category id etc. it is like a join but much simpler. It is why there are only two fields.
This table is temporary: you do not need to delete it at the end of the script. It does not belong to your model.
You will need to reload completly this table (it is not a big one: 2 fields only, few lines compared to the fact table) for any load.
If you need to apply this lookup to an incremental load, I think you will need to do it into a temp table and afterwards to concatenate with your target table (concatenate ... resident load)
Fabrice
.png "Luminary Alumni"){kind=icon}