You already created a job for loading the dimensions and another job for loading the fact.
In this section, you will put them together in a single main job:
Create a new job in the same folder in which you saved the mentioned jobs. Name this
job load_dm_sales.kjb
.Drag to the canvas a START and two Job job entries, and link them one after the other.
Use the first job entry to execute the job that loads the dimensions.
Use the second job entry to execute the job you just created for loading the fact table.
Save the job. This is how it looks:
Press F9 to run the job.
As arguments, provide a new range of dates:
2009-09-01
,2009-09-30
. Then press Launch.The dimensions will be loaded first, followed by the loading of the fact table.
The Job metrics tab in the Execution results window shows you the whole process running. As usual, you may drill-down and do sniff-testing to see that everything is running as you expect.
Exploring the database you'll see once again...