Loading junk dimensions

A junk dimension is an abstract dimension that groups unrelated low-cardinality flags, indicators, and attributes. Each of these items could technically be a dimension on its own, but grouping them into a junk dimension has the advantage of keeping your database model simple. It also saves space and contributes to better performance.

An example of a junk dimension in our model could be one that puts together the payment and buy method. The way to load the dimension is quite the same as the one explained for mini dimensions.

Get Learning Pentaho Data Integration 8 CE - Third Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.