- Home
- Interview Questions
- Data Warehousing
A lookup table is the table placed on the target table based upon the primary key of the target, it just updates the table by allowing only modified (new or updated) records based on the lookup condition.
Conformed dimensions mean the exact same thing with every possible fact table to which they are joined. They are common to the cubes.
Non‐additive facts are facts that cannot be summed up for any of the dimensions present in the fact table. However they are not considered as useless. If there are changes in dimensions the same facts can be useful.
A fact table which does not contain numeric fact columns it is called factless facts table.
An active data warehouse provides information that enables decision‐makers within an organization to manage customer relationships nimbly, efficiently and proactively.
|
|
||||||||||||||||||||||||||||
