Running SCM Warehouse Implementation Jobs
This section discusses how to run all the ETL implementation jobs for the SCM Warehouse, in the following order:
SCM - OWS jobs.
Global dimension jobs for SCM.
Local dimension jobs for SCM.
Global - OWE jobs for SCM.
SCM - OWE jobs.
SCM - SKU jobs.
Running SCM - OWS Jobs
The first step in implementing the SCM Warehouse is to run the SCM - OWS jobs. These jobs consist of SCM-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.
See .Verifying ETL Components Have Imported Properly
SCM - OWS Hash File Jobs
Perform the following steps to run the SCM - 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: SCM_E, OWS, Base, Load_Hash_Files, Server.
Select each SCM - 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.
SCM - OWS Jobs
Perform the following steps to run the SCM - OWS jobs:
In IBM WebSphere DataStage Director, navigate to the SCM - OWS jobs by expanding the nodes in the left navigation panel using the following path: SCM_E, OWS, Base, Load_Tables, Sequence.
Select each SCM - 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 SCM
The second step in implementing the SCM Warehouse is to run the global dimension jobs for SCM. 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 SCM
The third step in implementing the SCM Warehouse is to run the local dimension jobs for SCM. 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: 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: SCM_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: SCM_E, Local_Dimensions, OWS_To_MDW, 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: SCM_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 Global - OWE Jobs for SCM
The fourth step in implementing the SCM Warehouse is to run the Global - OWE jobs for SCM. These jobs consist of SCM Global - OWE hash file jobs and standard Global - OWE jobs. Run the hash file jobs first, as the tables that they load are required to run your standard SCM Global - OWE jobs.
Global - OWE Hash File Jobs
Perform the following steps to run the Global - OWE hash file jobs individually:
In IBM WebSphere DataStage Director, navigate to the Global - OWE hash file jobs by expanding the nodes in the left navigation panel using the following path: OWE_E, Global_D00, Base, Load_Hash_Files, Server.
Select each Global - OWE 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.
Global - OWE Dimension Jobs
Perform the following steps to run the Global - OWE dimension jobs individually:
In IBM WebSphere DataStage Director, navigate to the Global - OWE dimension jobs by expanding the nodes in the left navigation panel using the following path: OWE_E, Global_D00, Base, Load_Tables, Sequence.
Select each Global - OWE 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.
Running SCM - OWE Jobs
The fifth step in implementing the SCM Warehouse is to run the SCM - OWE jobs. These jobs consist of SCM - OWE hash file jobs and standard SCM - OWE jobs. Run the hash file jobs first, as the tables that they load are required to run your standard SCM - OWE jobs.
SCM - OWE Hash File Jobs
Perform the following steps to run the SCM - OWE hash file jobs individually:
In IBM WebSphere DataStage Director, navigate to the SCM - OWE hash file jobs by expanding the nodes in the left navigation panel using the following path: OWE_E, SCM, Base, Load_Hash_Files, Server.
Select the each SCM - OWE 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.
SCM - OWE Jobs
Perform the following steps to run the SCM - OWE jobs individually:
In IBM WebSphere DataStage Director, navigate to the SCM - OWE jobs by expanding the nodes in the left navigation panel using the following path: OWE_E, SCM, Base, Load_Tables, Sequence.
Select each SCM - OWE 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 SCM SKU Jobs
The sixth and final step in implementing the SCM Warehouse is to run the SCM 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 SCM SKU jobs individually or together using the master sequence job.
SCM SKU Hash File Jobs
Perform the following steps to run the SCM SKU hash file jobs individually:
In IBM WebSphere DataStage Director, navigate to the SCM SKU hash file jobs by expanding the nodes in the left navigation panel using the following path: SCM_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 SCM 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: SCM_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.
SCM Dimension Jobs
Perform the following steps to run the SCM dimension jobs individually:
In IBM WebSphere DataStage Director, navigate to the SCM dimension jobs by expanding the nodes in the left navigation panel using the following path: SCM_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 SCM 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: SCM_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.
SCM Fact Jobs
Perform the following steps to run the SCM fact jobs individually:
In IBM WebSphere DataStage Director, navigate to the SCM fact jobs by expanding the nodes in the left navigation panel using the following path: SCM_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: SCM_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.