Skip to Main Content
Return to Navigation

Running the Tree and Recursive Hierarchy ETL Process

After setting up the hierarchy parameters using the appropriate PeopleSoft Internet Architecture pages, you are ready to run the Tree and Recursive Hierarchy ETL process.

This section discusses how to run the tree and recursive hierarchy ETL process, which consist of the following steps:

  1. Running hash file hierarchy jobs.

  2. Running OWS hierarchy jobs.

  3. Running hierarchy utility jobs.

Running Hash File Hierarchy Jobs

Perform the following steps to run the hash file hierarchy jobs:

  1. In IBM WebSphere DataStage Director, navigate to the hash file hierarchy jobs by expanding the nodes in the left navigation panel, using the following path: Jobs, EPM_Utilities, Tree_Recursive_Hierarchy, Load_Hash_Files.

  2. Select all the jobs in the Job Status view and select Job, Run Now... from the menu.

    The Job Run Options box appears.

  3. 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 OWS Hierarchy Jobs

This step is required only when there are source database tree hierarchies.

Perform the following steps to run the OWS hierarchy jobs:

  1. In IBM WebSphere DataStage Director, navigate to the OWS hierarchy jobs by expanding the nodes in the left navigation panel, using the following path: Jobs, EPM_Utilities, Tree_Recursive_Hierarchy, Trees, ESourceTrees, StagingTreeMetadata, HCM, SEQ_J_Stage_[table name].

  2. Select all jobs in the Job Status view and select Job, Run Now... from the menu.

    The Job Run Options box appears.

  3. 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 Hierarchy Utility Jobs

Perform the following steps to run the hierarchy utility jobs:

  1. In IBM WebSphere DataStage Director, navigate to the J_Hierarchy_Startup_Process job by expanding the nodes in the left navigation panel, using the following path: Jobs, EPM_Utilities, Tree_Recursive_Hierarchy, Init_Process, J_Hierarchy_Startup_Process.

  2. Select the job in the Job Status view and select Job, Run Now... from the menu.

    The Job Run Options box appears.

  3. Update the Hierarchy Group ID and Hierarchy Sequence Number job parameters with the appropriate values.

    To process all the hierarchies under a single group, provide the appropriate numerical value for the group ID. The sequence number can be left blank.

    To process a single hierarchy, both the Hierarchy Group ID and Hierarchy Sequence Number should be given while running the job.

  4. Use the Populate Language Data field to specify whether you want to insert related language data in hierarchy and relationship related language tables.

  5. Click Run.

    The job is scheduled to run with the current date and time, and the job's status is updated to Running.