Junk Dimension | Gability
It used to reduce the number of dimensions (low-cardinality columns) in the dimensional model and reduce the number of columns in the fact table. It is a collection of random transnational codes, flags, or text attributes. It optimizes space as fact tables should not include low-cardinality or text fields. It mainly includes measures, foreign keys, and degenerate dimension keys. We must split the Junk dimension into more dimensions in case the size grows by the time. It is easy to calculate the expected number of rows as it is the total number of combinations between the low-cardinality attributes; 3 columns each have 3 values total = 3 * 3 = 9. Overview | Ch.01: Intro Last updated on Jan 7, 2020 GABILITY © 2023 - All rights reserved · Powered by the Academic theme for Hugo.
Explore this link on the map →