General Datawarehousing Question:

Download Job Interview Questions and Answers PDF

What is a lookup table?

General Datawarehousing Interview Question
General Datawarehousing Interview Question

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.

Download General Datawarehousing Interview Questions And Answers PDF

Previous QuestionNext Question
What is Snow Flake Schema?What is the Differences between star and snowflake schemas?