There are three types of dimensions called Confirm dimensions, junk dimensions, degenerated dimensions.
Confirm dimension: Confirm dimension, also referred to as Role-playing dimension, is sharable across the data model.
Junk dimension: Lumping of small dimensions to form a single dimension together is called as Junk dimension. Grouping and moving them to a different single dimension is referred to as a junk dimension.
Degenerated dimensions: Degenerated Dimension does not contain the dimension id in the dimension table. It only includes the values in the fact table.
Posted Date:- 2021-09-28 00:35:06