Running Campus Solutions Warehouse Implementation Jobs
This section discusses how to run all the ETL implementation jobs for the Campus Solutions Warehouse, in the following order:
Campus Solutions Warehouse - OWS jobs.
Global dimension jobs for Campus Solutions Warehouse.
Local dimension jobs for Campus Solutions Warehouse.
Campus Solutions Warehouse - SKU jobs.
Running Campus Solutions Warehouse - OWS Jobs
The first step in implementing the Campus Solutions Warehouse is to run the Campus Solutions Warehouse - OWS jobs. These jobs consist of Campus Solutions Warehouse-specific hash file jobs and OWS jobs. Run the hash file jobs first, as the tables that they load are required to run your standard OWS jobs.
As with most prepackaged jobs, you can use the Master Run Utility to automatically run a set of jobs located in a flat file on the IBM WebSphere DataStage Server. When you use the Master Run Utility, it reads a list of jobs that are present in a specified flat file and triggers the jobs to run in serial mode, using the dependency logic specified in the Input flat file.
Campus Solutions Warehouse - OWS Hash File Jobs
Perform the following steps to run the Campus Solutions Warehouse - OWS hash file jobs:
In IBM WebSphere DataStage Director, navigate to the hash file jobs by expanding the nodes in the left navigation panel using the following path: CS_E, OWS, Base, Load_Hash_Files, Server.
Select each CS Warehouse - OWS hash file job in the Job Status view and select Job, Run Now... from the menu.
The Job Run Options box appears.
Update the job parameters if necessary and click Run.
The job is scheduled to run with the current date and time and the job's status is updated to Running.
Campus Solutions Warehouse - OWS Jobs
Perform the following steps to run the Campus Solutions Warehouse - OWS jobs:
In IBM WebSphere DataStage Director, navigate to the CS Warehouse - OWS jobs by expanding the nodes in the left navigation panel using the following path: CS_E, OWS, Base, Load_Tables, Sequence.
Select each CS Warehouse - OWS job in the Job Status view and select Job, Run Now... from the menu.
The Job Run Options box appears.
Update the job parameters if necessary and click Run.
The job is scheduled to run with the current date and time and the job's status is updated to Running.
Running Global Dimension Jobs for Campus Solutions Warehouse
The second step in implementing the Campus Solutions Warehouse is to run the global dimension jobs for Campus Solutions Warehouse. These jobs consist of global dimension hash file jobs and global dimension jobs. Run the hash file jobs first, as the tables that they load are required to run your standard global dimension jobs.
Note: You can run global dimension jobs individually or together using the master sequence job.
Global Dimension Hash File Jobs
Perform the following steps to run the global dimension hash file jobs individually:
In IBM WebSphere DataStage Director, navigate to the global dimension hash file jobs by expanding the nodes in the left navigation panel using the following path: Global_Dimensions_E, OWS_To_MDW, Base, Load_Hash_Files, Server.
Select each global dimension hash file job in the Job Status view and select Job, Run Now... from the menu.
The Job Run Options box appears.
Update the job parameters if necessary and click Run.
The job is scheduled to run with the current date and time, and the job's status is updated to Running.
Perform the following steps to run the global dimension hash file jobs together using the master sequence job:
In IBM WebSphere DataStage Director, navigate to the master sequence job by expanding the nodes in the left navigation panel using the following path: Global_Dimensions_E, Master_Sequence.
Select the global dimension master sequence job in the Job Status view and select Job, Run Now... from the menu.
The Job Run Options box appears.
Update the job parameters if necessary and click Run.
The job is scheduled to run with the current date and time, and the job's status is updated to Running.
Global Dimension Jobs
Perform the following steps to run the global dimension jobs individually:
In IBM WebSphere DataStage Director, navigate to the global dimension hash file jobs by expanding the nodes in the left navigation panel using the following path: Global_Dimensions_E, OWS_To_MDW, Base, Load_Hash_Files, Sequence.
Select a global dimension job in the Job Status view and select Job, Run Now... from the menu.
The Job Run Options box appears.
Update the job parameters if necessary and click Run.
The job is scheduled to run with the current date and time, and the job's status is updated to Running.
Perform the following steps to run the global dimension jobs together using the master sequence job:
In IBM WebSphere DataStage Director, navigate to the master sequence job by expanding the nodes in the left navigation panel using the following path: Global_Dimensions_E, Master_Sequence.
Select the master sequence job in the Job Status view and select Job, Run Now... from the menu.
The Job Run Options box appears.
Update the job parameters if necessary and click Run.
The job is scheduled to run with the current date and time, and the job's status is updated to Running.
Running Local Dimension Jobs for Campus Solutions Warehouse
The third step in implementing the Campus Solutions Warehouse is to run the local dimension jobs for Campus Solutions Warehouse. These jobs consist of local dimension hash file jobs and local dimension jobs. Run the hash file jobs first, as the tables they load are required to run your standard global dimension jobs.
Note: You can run local dimension jobs individually or together using the master sequence job.
Local Dimension Hash File Jobs
Perform the following steps to run the local dimension hash file jobs individually:
In IBM WebSphere DataStage Director, navigate to the global dimension hash file jobs by expanding the nodes in the left navigation panel using the following path: CS_E, Local_Dimensions, OWS_To_MDW, Base, Load_Hash_Files, Server.
Select each local dimension hash file job in the Job Status view and select Job, Run Now... from the menu.
The Job Run Options box appears.
Update the job parameters if necessary and click Run.
The job is scheduled to run with the current date and time and the job's status is updated to Running.
Perform the following steps to run the local dimension hash file jobs together using the master sequence job:
In IBM WebSphere DataStage Director, navigate to the master sequence job by expanding the nodes in the left navigation panel using the following path: CS_E, Local_Dimensions, Master_Sequence.
Select the master sequence job in the Job Status view and select Job, Run Now... from the menu.
The Job Run Options box appears.
Update the job parameters if necessary and click Run.
The job is scheduled to run with the current date and time and the job's status is updated to Running.
Local Dimension Jobs
Perform the following steps to run the local dimension jobs individually:
In IBM WebSphere DataStage Director, navigate to the local dimension jobs by expanding the nodes in the left navigation panel using the following path: CS_E, Local_Dimensions, OWS_To_MDW, Dimensions, Base, Load_Tables, Sequence.
Select each local dimension job in the Job Status view and select Job, Run Now... from the menu.
The Job Run Options box appears.
Update the job parameters if necessary and click Run.
The job is scheduled to run with the current date and time and the job's status is updated to Running.
Perform the following steps to run the local dimension jobs together, using the master sequence job:
In IBM WebSphere DataStage Director, navigate to the master sequence job by expanding the nodes in the left navigation panel using the following path: CS_E, Local_Dimensions, Master_Sequence.
Select the master sequence job in the Job Status view and select Job, Run Now... from the menu.
The Job Run Options box appears.
Update the job parameters if necessary and click Run.
The job is scheduled to run with the current date and time, and the job's status is updated to Running.
Running Campus Solutions Warehouse SKU Jobs
The fourth and final step in implementing the Campus Solutions Warehouse is to run the Campus Solutions Warehouse SKU jobs. These jobs consist of hash file jobs, dimension jobs, and fact jobs. Run the hash file jobs first, as the tables that they load are required to run your dimension and fact jobs.
Note: You can run Campus Solutions Warehouse SKU jobs individually or together using the master sequence job.
Campus Solutions Warehouse SKU Hash File Jobs
Perform the following steps to run the Campus Solutions Warehouse SKU hash file jobs individually:
In IBM WebSphere DataStage Director, navigate to the CS Warehouse SKU hash file jobs by expanding the nodes in the left navigation panel using the following path: CS_E, [SKU/Data Mart Name], [Business Process], OWS_To_MDW, Dimensions, Base, Load_Hash_Files, Server.
Select each hash file job in the Job Status view and select Job, Run Now... from the menu.
The Job Run Options box appears.
Update the job parameters if necessary and click Run.
The job is scheduled to run with the current date and time and the job's status is updated to Running.
Perform the following steps to run the CS Warehouse SKU hash file jobs together using the master sequence job:
In IBM WebSphere DataStage Director, navigate to the master sequence job by expanding the nodes in the left navigation panel using the following path: CS_E, [SKU/Data Mart Name], [Business Process], Master_Sequence.
Select the master sequence job in the Job Status view and select Job, Run Now... from the menu.
The Job Run Options box appears.
Update the job parameters if necessary and click Run.
The job is scheduled to run with the current date and time and the job's status is updated to Running.
Campus Solutions Warehouse Dimension Jobs
Perform the following steps to run the Campus Solutions Warehouse dimension jobs individually:
In IBM WebSphere DataStage Director, navigate to the CS Warehouse dimension jobs by expanding the nodes in the left navigation panel using the following path: CS_E, [SKU/Data Mart Name], [Business Process], OWS_To_MDW, Dimensions, Base, Load_Tables, Sequence.
Select each dimension job in the Job Status view and select Job, Run Now... from the menu.
The Job Run Options box appears.
Update the job parameters if necessary and click Run.
The job is scheduled to run with the current date and time and the job's status is updated to Running.
Perform the following steps to run the CS Warehouse dimension jobs together using the master sequence job:
In IBM WebSphere DataStage Director, navigate to the master sequence job by expanding the nodes in the left navigation panel using the following path: CS_E, [SKU/Data Mart Name], [Business Process], Master_Sequence..
Select the master sequence job in the Job Status view and select Job, Run Now... from the menu.
The Job Run Options box appears.
Update the job parameters if necessary and click Run.
The job is scheduled to run with the current date and time, and the job's status is updated to Running.
Campus Solutions Warehouse Fact Jobs
Perform the following steps to run the Campus Solutions Warehouse fact jobs individually:
In IBM WebSphere DataStage Director, navigate to the CS Warehouse fact jobs by expanding the nodes in the left navigation panel using the following path: CS_E, [SKU/Data Mart Name], [Business Process], OWS_To_MDW, Facts, Base, Load_Tables, Sequence.
Select each fact job in the Job Status view and select Job, Run Now... from the menu.
The Job Run Options box appears.
Update the job parameters if necessary and click Run.
The job is scheduled to run with the current date and time and the job's status is updated to Running.
Perform the following steps to run the fact jobs together using the master sequence job:
In IBM WebSphere DataStage Director, navigate to the master sequence job by expanding the nodes in the left navigation panel using the following path: CS_E, [SKU/Data Mart Name], [Business Process], Master_Sequence.
Select the master sequence job in the Job Status view and select Job, Run Now... from the menu.
The Job Run Options box appears.
Update the job parameters if necessary and click Run.
The job is scheduled to run with the current date and time and the job's status is updated to Running.