BRIAN CIAMPA
Enabling excellent decision making through data warehousing and business intelligence

Terms

This page contains some basic definitions of data warehousing concepts. For a pictorial representation, take a look at the basic and advanced concepts pages.

General Design

What is Dimensional Modeling?

Dimensional Modeling is a design technique that groups data...

Show More

What is a Star Schema?

A star schema consists of one fact table and its associated...

Show More

What is a Snowflake Schema?

Some data warehouse architects choose to fully normalize...

Show More

Facts

What is a Fact?

A fact is an element of a dimensional model that is measured...

Show More

What is a Fact Table?

A fact table is a table in a data warehouse that is designed to...

Show More

What is a Factless Fact Table?

A factless fact table is a fact table that contains no measures...

Show More

Dimensions

What is a Dimension?

A dimension is an element of a dimensional model that describes...

Show More

What is a Dimension Table?

A dimension table in a data warehouse is designed to store the...

Show More

What is a Conformed Dimension?

If a fact table that contains salary data includes a foreign key...

Show More

What is a Degenerate Dimension?

A degenerate dimension is a dimension value that resides in...

Show More