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:
js_dwdatabases are accessible from PDI.
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_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 ...