Dimensional Data modelling Flashcards
The process of organizing and preparing data for analysis is called as
data staging
which of these ensures data becomes consistent, relevant and free from ambiguities
a) data provisioning
b) data gathering
c) data staging
c)data staging
defining data and their relationships are called
data modeling
data warehouse has ________tables
denormalized
The tables in DW are ______-only
read-only hence normalization not required
DB architecture with summarised, harmonized, cleansed, consolidated data is called
data warehouse
operational data –txn data are both one and the same
T/F
T
Detailed view of the fact table is called
dimensional table
Number of dimension in star schema is fixed
T/F
F depends on analytics requirements
Why is star schema called multidimensional structure
number of dimesnions is not fixed
Default numnber of dimensions in star schema is
3
fact table contans ________& _______data
txn and organizational data
the fact table contains txn attributes also called as
key /measures
detailed view of fact is called
dimensional tables
fact table has separate currency unit as attribute T/F
T. to store key measures in different currenncies