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