Do you know what a local lookup is?
This function is similar to a mlookup…the difference being that this funtion returns NULL when there is no record having the value that has been mentioned in the arguments of the function.
If it finfs the matching record it returns the complete record..that is all the fields along with their values corresponding to the expression mentioned in the lookup local function.
eg: lookup_local( “LOOKUP_FILE”,81) -> null
if the key on which the lookup file is patitioned does not hold any value as mentioned.
Explore posts in the same categories: Data WareHousing Interview Questions