/
Kimball Architecture
Save to my account
Sign up
Report Bug
Kimball Architecture
View
Lect2_ DWArchitectures..pdf Flashcards
Study
Question
What is the main focus of Ralph Kimball's approach to Data Warehousing?
Answer
The purpose of a Data Warehouse is a copy of transaction data specifically structured for query and analysis.
Question
What does Kimball's approach to Data Warehousing emphasize in terms of understanding?
Answer
Understand and document the business processes, business needs, and business questions being asked.
Question
What are the steps in Kimball's ETL process?
Answer
Build ETL pipelines that extract, transform, and load data into a denormalized data model.
Question
What types of schemas are used in a dimensional model according to Kimball?
Answer
The dimensional model is built as a star schema or a snowflake schema.
Question
Where is the dimensional model usually built?
Answer
The dimensional model is usually built around and within dimensional data marts for specific departments.
Question
List one advantage of Kimball's Dimensional Modelling approach.
Answer
Simplicity - The architecture is much simpler and faster to design and set up.
Question
Why is Kimball's Dimensional Modelling approach considered understandable?
Answer
It is easy to understand and gears answer organization needs.
Question
What is a skills-related advantage of Kimball's approach?
Answer
Requires a less number of highly skilled engineers and less technical knowledge.
Question
What is a disadvantage related to data in Kimball's approach?
Answer
Data Redundancy - Because data is loaded into a dimensional model, it is not normalized.
Question
What does Kimball's approach say about a single source of truth?
Answer
There is no Single Source of Truth; the warehouse is designed and organized around data marts.
Question
What is a disadvantage of Kimball's Dimensional Modelling approach related to flexibility?
Answer
It is Less Flexible and Incomplete due to the as-needed paradigm and is specific to needs.
