Running ETL Jobs
This table provides answers to questions about running ETL jobs.
Question |
Answer |
---|---|
How do I identify ETL jobs that are needed based on the license code or my implementation plans? |
|
What do the OWS to OWE (D00) jobs do? |
The D00 job from OWS to OWE loads data from staging tables to _D00 tables in the OWE database. |
What do the OWS to OWE (F00) jobs do? |
The F00 job from OWS to OWE loads data from staging tables to _F00 tables in the OWE database. |
What do the OWS to MDW (Global Dimensions) jobs do? |
The Global Dimension jobs loads data from staging tables to dimension tables. Global Dimensions are dimension tables that are shared across warehouses. |
What do the OWS to MDW (Local Dimensions) jobs do? |
The Local Dimension jobs loads data from staging tables to dimension tables. Local Dimensions are dimension tables that are shared across different marts in a warehouse. |
What do the OWS to MDW (data mart dimensions and facts) jobs do? |
The dimension and fact job loads data from staging tables to dimension or fact tables. A dimension contains a key (SID) value and attributes used for slicing and dicing measures located in a fact table. |
What do the OWE to MDW (Dimensions and Facts) jobs do? |
The dimension and fact job loads data from OWE tables (D00 or F00) to dimension or fact tables. A dimension contains a key (SID) value and attributes used for slicing and dicing measures located in a fact table. |
How do uncompiled jobs affect EPM? |
All server jobs/sequencers should be compiled before running. Uncompiled jobs will not run and have to be compiled using the Designer prior to running. |
In what order must I run different categories of jobs? |
|
How are Master Sequences used to load data marts? |
|
Can I use the People Tools Process Scheduler to trigger jobs? |
No, you cannot use the Process Scheduler to trigger jobs. To schedule jobs, you can use the DataStage Scheduler or any other third party scheduling tool. |
When do I use the Master Run utility in the utilities folder? |
The Master_Run_Utility can be used to run the set of jobs that are present in a flat file in the DataStage Server. This utility will read the list of jobs that are present in the file and trigger them in a serial mode, by taking care of dependency logic as mentioned in the Input Flat file. Master_Run_Utility can be used to run any jobs in a dependent or independent mode. |