Skip to Main Content
Return to Navigation

Running Shared Lookup Jobs

Shared lookups function the same as hash file lookups—they act as views of specific EPM warehouse tables and contain only a subset of the data available in a warehouse table. These streamlined versions of warehouse tables are used to perform data validation (lookups) within an ETL job and select specific data from lookup tables (such as sourceID fields in dimensions). The only difference between a regular lookup and a shared lookup is that the shared lookups are used across all EPM products.

Because shared lookups are essential in the lookup process, jobs cannot function properly until all hash files are created and populated with data. Before you run any job that requires a hash file, you must first run all jobs that create and load the hash files—also called initial hash file load jobs.

Steps Required to Run Shared Lookup Jobs

Perform the following steps to run the shared lookup jobs:

  1. In DataStage Designer, attach to your project and expand the Shared_Lookups node in the left navigation panel of the window.

    The following sub-folders exist in the Shared_Lookups node:

    • Control_Tables

    • DimensionMapper_Lookups

    • Language_Lookups

    • System_Lookups

  2. Select one of the sub-folders.

  3. Select the lookup jobs in the Job Status view and select Job, Run Now... from the menu.

    The Job Run Options box appears.

  4. 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.

  5. Repeat steps two and three for the remaining sub-folders.