Start a Mapping or Process Flow from OWB Browser

Basically, we start a Mapping or Process Flow from Oracle Warehouse Builder (OWB) Design Client. But actually we can also start a Mapping or Process Flow from OWB Browser. This paper will introduce the Start Report first and then introduce how to start/rerun a Mapping or Process Flow from OWB Browser.

Start Report

Start Report is used to start an execution of a Mapping or Process Flow. So there are two kinds of Start Report: Mapping Start Report (See Figure 1) and Process Flow Start Report (See Figure 2). Start Report shows the Mapping or Process Flow identification properties, including latest deployment and latest execution, lists all execution parameters for the Mapping or Process Flow, which were specified by the latest deployment, and assigns parameter default values from the latest deployment specification.

You can do a couple of things from Start Report:

  • Sort execution parameters on name, category.
    • Table 1 lists all parameters of a Mapping.
    • Table 2 lists all parameters of a Process Flow.
  • Change values of any input parameter where permitted. For some parameters, selection lists are provided. For example, Mapping's parameter Audit Level has a selection list.
  • Reset all parameter settings to their default values.
  • Apply basic validation to parameter values before starting an execution.
  • Start the Mapping or Process Flow, which means it is executed immediately.
  • Navigate to Deployment Report for latest deployment details of the Mapping or Process Flow.
  • Navigate to Execution Job Report for latest execution of current Mapping or Process Flow
  • Link to on-link help Warehouse Report Page, Deployment Report, Execution Report, Execution Schedule Report and Execution Summary Report.

MappingStartReport

Figure 1 Mapping Start Report

Table 1 Execution Parameters and default values for a Mapping

Category

Name

Mode

Input Value

System

Audit Level

In

Error Details

System

Bulk Size

In

1000

System

Commit Frequency

In

1000

System

EXECUTE_RESUME_TASK

In

FALSE

System

FORCE_RESUME_OPTION

In

FALSE

System

Max No of Errors

In

50

System

NUMBER_OF_TIMES_TO_RETRY

In

2

System

Operating Mode

In

Set Based Fail Over to Row Based

System

PARALLEL_LEVEL

In

0

System

Procedure Name

In

main

System

Purge Group

In

WB

PfStartReport

Figure 2 Process Flow Start Report

Table 2 Execution Parameters and default values for a Process Flow

Category

Name

Mode

Input Value

System

EVAL_LOCATION

In

 

System

Item Key

In-Out

 

System

Item Type

In

PFPKG_1

Start a Mapping or Process Flow

To navigate to Start Report, it's better to login OWB Browser with Control Center option; if not, after logging in OWB Browser, go to Control Center first. Then you can follow the ways introduced in this section to navigate to Start Report.

One more thing you need to pay attention to is that you are not allowed to deploy any Mappings and Process Flows from OWB Browser as it's not supported. So it's necessary to deploy the Mappings and Process Flows first before starting them from OWB Browser.

If you have deployed a Mapping or Process Flow but have not started it, please navigate from Object Summary Report or Deployment Schedule Report to Start Report.

1. Navigating from Object Summary Report to Start Report

  • Open the Object Summary Report to see all deployed Mappings and Process Flows.
  • Click the Mapping Name or Process Flow Name link to see its Deployment Report.
  • Select the Start link in the Available Reports tab for the given Mapping or Process Flow to display a Start Report for the Mapping or Process Flow.
  • The execution parameters have the default deployment-time settings.
  • Change any of the input parameter values as required.
  • Click Start Execution button to execute the Mapping or Process Flow.

2. Navigating from Deployment Schedule Report to Start Report

  • Open the Deployment Schedule Report to see deployment details of Mapping and Process Flow.
  • Expand the project trees to find the deployed Mappings and Process Flows.
  • Click the Mapping Name or Process Flow Name link to see its Deployment Report.
  • Select the Start link in the Available Reports tab for the given Mapping or Process Flow to display a Start Report for the Mapping or Process Flow.
    • The execution parameters have the default deployment-time settings.
  • Change any of the input parameter values as required.
  • Click Start Execution button to execute the Mapping or Process Flow.

Re-run a Mapping or Process Flow

If you have executed a Mapping or Process Flow, you can navigate from Object Summary Report, Deployment Schedule Report, Execution Summary Report or Execution Schedule Report to Start Report.

1. Navigating from the Execution Summary Report to Start Report

  • Open the Execution Summary Report to see all execution jobs including Mapping jobs and Process Flow jobs.
  • Click on the Mapping Name or Process Flow Name to see its Execution Report.
  • Select the Start link in the Available Reports tab for the given Mapping or Process Flow to display a Start Report for the Mapping or Process Flow.
    • The execution parameters have the default deployment-time settings.
  • Change any of the input parameter values as required.
  • Click Start Execution button to execute the Mapping or Process Flow.

2. Navigating from the Execution Schedule Report to Start Report

  • Open the Execution Schedule Report to see list of all executions of Mapping and Process Flow.
  • Click on the Mapping Name or Process Flow Name to see its Execution Report.
  • Select the Start link in the Available Reports tab for the given Mapping or Process Flow to display a Start Report for the Mapping or Process Flow.
    • The execution parameters have the default deployment-time settings.
  • Change any of the input parameter values as required.
  • Click Start Execution button to execute the Mapping or Process Flow.

If the execution of a Mapping or Process Flow is successful, you will see this message from the Start Report: Start Execution request successful. (See Figure 3)

startSuccess

Figure 3 Execution Result

You can also confirm the execution of the Mapping or Process Flow by referring to Execution Report of the current Mapping or Process Flow by clicking the link in the Available Reports tab for the given Mapping or Process Flow. One new record of execution job details is added to Execution Report of the Mapping or Process Flow which shows the details of the execution such as Start Time, Elapsed Time, Status, the number of records selected, inserted, updated, deleted etc.

Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

ETL, CDC, Real-Time DI and Data Quality for the Oracle Database from the inside.

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today