Pentaho Data Integration Quick Start Guide

Loading a dimension with a dimension lookup/update step

The PERSONS dimension is meant to hold the names of the players. The main difference, as compared to the previous dimension, is that this one has a corresponding table in the source database. The following is the DDL for the dimension table:

CREATE TABLE DIM_PERSONS ( id integer NOT NULL, first_name CHAR(25) NOT NULL DEFAULT 'N/A', last_name CHAR(25) NOT NULL DEFAULT 'N/A', entity_id integer NOT NULL DEFAULT 0, version integer, date_from TIMESTAMP, date_to TIMESTAMP, PRIMARY KEY (id));

In this table, the id is the surrogate key, while the entity_id corresponds to the business key.

The following instructions describe how to load the table:

1. Create a transformation.
2. Drag a Table input ...