Table of Contents

Search

  1. Preface
  2. Using the Designer
  3. Working with Sources
  4. Working with Flat Files
  5. Working with Targets
  6. Mappings
  7. Mapplets
  8. Mapping Parameters and Variables
  9. Working with User-Defined Functions
  10. Using the Debugger
  11. Viewing Data Lineage
  12. Comparing Objects
  13. Managing Business Components
  14. Creating Cubes and Dimensions
  15. Using the Mapping Wizards
  16. Datatype Reference
  17. Configure the Web Browser

Designer Guide

Designer Guide

Scheduling Sessions and Workflows

Scheduling Sessions and Workflows

After you create mappings to load the star schemas, create sessions and workflows to run the mappings. To verify that the Integration Service loads each table appropriately, configure each session according to the mapping type you created.
To verify that the fact tables contain the most recent data, refresh all dimension tables before loading the fact table. You can accomplish this by creating a workflow that executes the dimension sessions before executing the fact session.
To verify that all dimension sessions successfully complete before the Integration Service runs a fact session, use the following workflow logic:
  1. Place all dimension sessions in the workflow before the fact session.
  2. Link all dimension sessions to a Decision task.
  3. Define the following decision condition:
    $
    <session_name1>
    .Status = SUCCEEDED AND $
    <session_name2>
    .Status = SUCCEEDED AND ... $
    <session_nameN>
    .Status = SUCCEEDED
  4. Place the fact session in the workflow after the Decision task, and link the Decision task to the fact session.
  5. Configure the following link condition from the Decision task to the fact session:
    $
    <Decision_name>
    .Condition = TRUE
For example, you create three sessions that load data to dimension tables and one session that loads data to a fact table.
The following figure shows the workflow you can create:
The start task links to s_dimension1, s_dimension2, and s_dimension3, which link to the sess_successful Decision task. sess_successful links to s_fact, depending on the $sess_successful condition.
Define the following decision condition for the sess_successful Decision task:
$s_dimension1.Status = SUCCEEDED AND $s_dimension2.Status = SUCCEEDED AND $s_dimension3.Status = SUCCEEDED
Define the following link condition for the link from the Decision task to the s_fact fact session:
$sess_successful.Condition = TRUE
To improve workflow performance, run the dimension sessions concurrently. Arrange the sessions in the workflow to start at the same time. If the Integration Service cannot start and run all dimension sessions concurrently due to the existing session load, you can run the dimension sessions sequentially by arranging the dimension sessions sequentially in the workflow.
If you have a dimension table that does not need to reload each time you run the workflow, you can disable that session.

0 COMMENTS

We’d like to hear from you!