Answer:
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.
| Previous Question | Next Question |
| What is Snow Flake Schema? | What is the Differences between star and snowflake schemas? |