Time for action – loading dimensions for the sales datamart
In this tutorial, you will load each dimension for the sales datamart and enclose them into a single job. Before starting, check the following things:
- Check that the database engine is up and that both the
js
and thejs_dw
databases are accessible from PDI. - If your time dimension table,
lk_time
, has data, truncate the table. You may do it by using the Truncate table [lk_time] option in the database explorer.
Tip
You may reuse the js_dw
database in which you have been loading data in previous chapters. There is no problem with that. However, creating a whole new database is preferred so that you can see how the entire process works.
The explanation will be focused on the general process. For ...
Get Pentaho 3.2 Data Integration Beginner's Guide 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.