Pentaho 3.2 Data Integration Beginner's Guide

Chapter 12

modifying a star model and loading the star with PDI

1	a	iii	As mentioned in Chapter 9, despite being designed for building Type II SCDs, the Dimension L/U step can be used for building Type I SCDs as well. So, you have two options: Reuse the table (modifying the transformation that loads it) and get the surrogate key with a Dimension L/U step, or use another table without all fields specific to Type II dimensions and, for getting the surrogate key, use a DB Lookup step. In any case, you may reuse the id_region field, as it is a integer and serves in any situation.
	b	i
	c	iii
2	a	ii	The dimension table has to have one record by month. Therefore a different table is needed. For the key you could use a string with the format ...