Running ETL Setup Jobs to Bring Source Data Into EPM
After you verify that all ETL components have been successfully imported and all ETL jobs compiled, you are ready to run the jobs which bring your source data into the EPM database (the OWS Load_Hash_Files and Load_Tables jobs).
You have the option of running these jobs manually or using the Master Run Utility.
To run the jobs automatically with the Master Run Utility, follow the steps provided in the ETL Configurations topic of this documentation.
To run the jobs manually, follow the steps described below.
Running Hash Files Setup Jobs Manually
Perform the following steps to manually run hash files setup jobs:
In DataStage Director, navigate to the hash file jobs by expanding the nodes in the left navigation panel using the following path: Setup_E, OWS, <Warehouse Code>,Base, Load_Hash_Files, Server.
Note: Warehouse Code refers to each of the EPM Warehouse products (for example CS Warehouse or HCM Warehouse).
Select each hash file setup 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 the Setup - OWS Jobs Manually
Perform the following steps to manually run setup - OWS jobs:
In DataStage Director, navigate to the setup jobs by expanding the nodes in the left navigation panel using the following path: Setup_E, OWS, <Warehouse Code>, Base, Load_Tables, Sequence.
Note: Warehouse Code refers to each of the EPM Warehouse products (for example, CS Warehouse or HCM Warehouse).
Select each setup - 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.