Typical artifact in data warehouse model
Here are data warehouse table types:
- Fact table
- Dimension table
- Dimension Hierarchy – Column Flattening table
- Dimension Hierarchy – Row Flattening table
- Mini-Dimension table
- Aggregate table
- Helper table
- Lookup Table – Providing multiple language and code support
- Cross Reference table
The above are the tables used in the BI queries.
There are also tables designed for ETL.