General Datawarehousing Interview Question:

What is a lookup table?

Submitted by: Administrator

A lookUp table is the one which is used when updating a warehouse. When the lookup is placed on the target table (fact table / warehouse) based upon the primary key of the target, it just updates the table by allowing only new records or updated records based on the lookup condition.
Submitted by: Administrator