Contents
What are different types of dimensions in data warehouse?
Following are the Types of Dimensions in Data Warehouse:
- Conformed Dimension.
- Outrigger Dimension.
- Shrunken Dimension.
- Role-playing Dimension.
- Dimension to Dimension Table.
- Junk Dimension.
- Degenerate Dimension.
- Swappable Dimension.
What are the dimensions of transactions?
Three dimensions were developed for characterizing transactions: uncertainty, frequency, and asset specificity, or the degree to which transaction-specific expenses were incurred. Transaction cost theory is built on assumptions of bounded rationality and opportunism, defined as self-interest with guile.
What is a dimension table in data warehouse?
A dimension table is a table in a star schema of a data warehouse. A dimension table stores attributes, or dimensions, that describe the objects in a fact table. In data warehousing, a dimension is a collection of reference information about a measurable event.
Why do we need staging table?
Staging tables provide a buffer between the warehouse and the data sources. There is one staging table for each source table or file. Staging tables duplicate source schema and add system attributes. Updates in operational data lead to new staging records.
What is transaction frequency?
Frequency refers to the number of times the transaction is expected to take place. If a transaction is a one-off transaction, it will not be efficient to devote significant resources to its coordination and control.
What is a specific asset?
Specific assets are assets that have a significantly higher value within a particular transacting. relationship than outside the relationship.
How are dimension tables used in a data warehouse?
In a data warehouse, these are often used as the result of a drill through query to analyze the source of an aggregated number in a report. You can use these values to trace back to transactions in the OLTP system. For example, receipt number does not have dimension table associated with it. Such details are just for information purpose
How are facts recorded in a data warehouse?
Warehouse facts are inherently historical since transactions happen on a transaction date, balances are kept on a balance date, and so on. The values of Dimensions are either static (date and time, limited code sets) or change slowly. Not every dimension change needs to be recorded as history, but many do.
What are the three master data tables in data warehouse?
Our data warehouse application consists of three master data tables, including: 1) MasterCust for customer master; 2) MasterProdHier for Product IDs and other dimensions pertaining to Products/Parts; and 3) MasterReps as the Sales Rep Master.
The Dimension tables are related to the Fact table by a surrogate keys. The Fact contains the measures of the data the business process wants to consume.