Loading a Type I SCD with a combination lookup/update step

We will explain the loading process of a Type I SCD by example. We will load the region dimension, which contains geographical information—cities and countries. The source of our dimension will be the cities and countries tables, and the dimension table to be loaded is lk_regions.

Note that we will take information from the operational database js and load a table in another database js_dw.

We load Type I SCDs with the Combination lookup/update step. Before loading the dimension, it's a good idea to take a look at the definition of the table so that we can identify the different kinds of fields needed to configure the Combination lookup/update step properly:

CREATE TABLE LK_REGIONS ...

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

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.