Tables: Physical groupings of related data

The different types of tables are

• Lookup tables: Attribute storage

• Relate tables: A unique case for relating attributes

• Fact tables: Fact data and levels of aggregation

While each type of table may function differently within the data warehouse, each type of table can be assigned a primary key that uniquely identifies the elements within the given table.