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?	See Understanding the EPM Lineage Spreadsheets.
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?	See Understanding the EPM Lineage Spreadsheets.
How are Master Sequences used to load data marts?	Loading Sequence for OWS: To run the OWS jobs, you can use the Master_Run_Utility, which reads the list of OWS jobs from a flat file and executes them in the specific order as mentioned in the input flat file. Using this Master_Run_Utility, you can run Hash Load jobs (first time to create the Hash Files), Base - Sequence Jobs, and Language Sequence jobs. Loading Sequence for OWE: To run the OWE jobs, you can use the Master_Run_Utility, which reads the list of OWS jobs from a flat file and executes them in the specific order as mentioned in the input flat file. Using this Master_Run_Utility, user can run Hash Load jobs (first time to create the Hash Files), D00, F00 and Language D00 jobs. Loading Sequence for MDW: To run the MDW Dimensions and Facts, user can run the Master_Sequence jobs that are present under the Master_Sequence category. Master_Sequence category will be present under all subject areas of the data mart node. Hence, there are four Master Sequence jobs for each subject area: Hash Load Jobs, Base - Dimensions, Facts and Language Dimensions. For Global Dimensions and Local Dimensions you can find 3 Master Sequence; Hash Load Jobs, Base – Dimensions and Language Dimensions. Alternately, you can also use Master_Run_Utility to run the MDW Dimensions and Facts, provided there is a loading sequence flat file present in the DataStage Server.
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.