In this section, 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_timehas data, truncate the table. Remember that you can do it by right-clicking on the table in the database explorer and selecting the Truncate Table option.
You may reuse the
js_dw database in which you have been loading data in previous chapters. There is no problem with that. However, dropping the database and creating the tables again is preferred so that you can see how the entire process works. ...