What is data warehouse schema outrigger?

Data Warehousing Questions



53 Short 38 Medium 47 Long Answer Questions Question Index

What is data warehouse schema outrigger?

In data warehousing, an outrigger schema refers to a dimensional schema that is attached to a fact table in order to provide additional dimensions. It is used to extend the existing dimensions and provide more detailed information for analysis and reporting purposes. The outrigger schema is typically linked to the main fact table through a foreign key relationship, allowing users to drill down into specific dimensions and analyze data at a more granular level.