Re: In Mapping Load if there is no value against the key,So what will be returned for that key
Case Key 1 :
The applymap will return the value 10. From my experience, applymap returns the first field that it finds in the table. This behaviour could change and it's not a good idea to have repeated id's in the table.
Case Key 6 :
When the applymap is not able to find a solution, it returns the map_id value, in this case 6. I don't know if you know that you can introduce a default value to return when no match is found.