Updated June 30, 2023
Introduction to Types of Dimensions
The table of dimensions contains the company data. In fact, tables of international key relations, the main keys of the dimensional tables, are used. And the remaining columns in the dimension are natural information, which is the company’s object information. The size of an object is a topological measure of the size of its shell. A rectangle is, for example, two-dimensional, and a cube is three-dimensional.
Top 9 Types of Dimension
Following are the Types of Dimension are explained below:
1. Conformed Dimensions
A dimension is considered a conformed dimension and is found in many places. A conformed dimension may be included in a single database, several data marts, or data warehouses with several truth tables.
2. Role-Playing Dimensions
For starters, a fact table can contain international keys for the ship date and the shipping date. But for foreign keys, the same date dimension features are valid, such that all foreign keys have the same dimension table added. The date component here plays several roles in the arrival and delivery date of the ship and hence its name.
3. Shrunken Dimensions
A shrunk dimension is another sub-set. For example, the fact table for orders which contain a foreign product main but a foreign product segment, which is in the product table, but is much less granular, may be included in the target fact table. One way to deal with the heterogeneous grain condition is to create a smaller dimension table with the crop group as its primary key. If the product dimension is black-snow, a different product type table is usually available, acting as the shrunk dimension.
4. Degenerate Dimensions
The degenerate dimension is given when the dimension attribute is stored in the fact table and not in a separate dimension table. In principle, these are dimensional keys for which no other attributes exist
5. Rapidly Changing Dimensions
An attribute of dimension that varies often is an attribute that changes rapidly. If you do not have to follow the changes, there would be no problem with the fast-changing attribute, but if you have to follow up the changes, a conventional methodology that changes slowly will create major inflation of the dimension. One solution involves moving the attribute to its own dimension with a different foreign key.
6. Junk Dimensions
A single table with various characteristics and irrelevant functionality to preclude a significant amount of international keys from appearing on the fact table is a garbage factor.
7. Inferred Dimensions
A dimension record may not yet be ready when loading reality documents. One approach is to create a null substitution key for all other functions.
8. Slowly Changing Dimensions
Attributes with a nature that would be prone to time shifts. The maintenance of a clear attribute history of improvements in the data warehouse relies on the market necessity
This is a guide to Types of Dimensions. Here we also discuss the introduction and top 8 types of dimensions and a detailed explanation. You may also have a look at the following articles to learn more –