Monday, 31 October 2022

What is a junk dimension?

A Junk Dimension is a dimension table consisting of attributes that does not belong in the fact table or in any of the existing dimension tables. 

The nature of these attributes is usually text or various flags.

for e.g. non-generic comments or just simple yes/no or true/false indicators.


No comments:

Post a Comment

How to perform regression testing in ETL?

Regression testing in ETL (Extract, Transform, Load) ensures that changes or updates to the ETL process do not negatively impact existing fu...