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