Generating Lineage Information for a Job

The Dynamic_Lineage_Generator worksheet contains a macro that generates a list of all the dependent jobs that are required for any ETL job. This will easily help you identify all the list of jobs to be run for a specific fact or dimension job.

To use the Dynamic Lineage Generator:

1. Access the Dynamic_Lineage_Generator worksheet.

2. Enter the job name in cell B1.

3. Click the Get Job Lineage button.

   The macro retrieves the lineage required for running this fact job from the setup, staging, and the dimension jobs and displays it in the cells below. The macro also copies the entire list of dependent jobs to the JobOrder worksheet, so you can identify the complete list to be run in sequence.

You must run the following prerequisite setup jobs before you run the jobs listed in the JobOrder worksheet:

• Setup_E\OWS\<Warehouse Name> Job Sequencer.

  For example Setup_E\OWS\FSCM Job Sequencer or Setup_E\OWS\CS Job Sequencer.

• Setup_E\Dimension mapper Job Sequencer.

• Run the Business Unit Wizard to populate the Dimension mapper tables.

  See .Understanding Warehouse Business Units, TableSet Sharing, and SetID Mapping

• Shared_Lookups\DimensionMapper_Lookups

• Shared_Lookups\Control_Tables

• Shared_Lookups\System_Lookups

• Shared_Lookups\Language_Lookups

• Setup_E\OWE Job Sequencer (this step does not apply to the Campus Solutions warehouse).

After you run the prerequisite setup jobs, then run the jobs listed in the JobOrder worksheet.