Obtaining the surrogate key for the junk dimension

As said before, the payment and buy methods could be stored in a junk dimension. A junk dimension can be loaded using a Combination L/U step. As all the fields in a junk dimension are part of the primary key, you don't need an extra Update step to load it. The following image shows you how to load this sample dimension:

Loading a Junk dimension

When you use a Combination L/U step, the step returns the generated key to you. So, the use of the step here to load and get the key at the same time fits perfectly.

If the dimension had been loaded previously, instead of a Combination L/U step, you ...

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.