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_dwdatabases 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.
You may reuse the
js_dwdatabase 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 ...