OWB - Process Flow

> Data Integration Tool (ETL/ELT) > Oracle Warehouse Builder

1 - About

Notes about process flow in OWB

The code generated from a process flow definition is in industry standard XML Process Definition Language (XPDL).

Advertising

3 - How to retrieve an activity ( mapping, process flow, ...) in a process flow ?

You can do that with the OWB - Public Views (metadata). Here below an example for a mapping :

SELECT PACKAGE_NAME, 
       ALL_IV_PROCESS_ACTIVITIES.PROCESS_NAME, 
       ALL_IV_PROCESS_ACTIVITIES.ACTIVITY_NAME, 
       ALL_IV_PROCESS_ACTIVITIES.ACTIVITY_TYPE 
  FROM ALL_IV_PROCESS_ACTIVITIES, 
       ALL_IV_PROCESSES
 WHERE ALL_IV_PROCESS_ACTIVITIES.BOUND_OBJECT_NAME = 'NameofTheMapping'
   AND ALL_IV_PROCESS_ACTIVITIES.PROCESS_ID = ALL_IV_PROCESSES.PROCESS_ID

4 - Activity

4.1 - Which type of activities can I have in a process flow ?

ACTIVITY_TYPE Description
PlSqlMapProcessNoteTag Mapping
SUBPROCESS Sub Process
ProcedureProcessNoteTag Procedure
FunctionProcessNoteTag Function
ABAPMapProcessNoteTag Abap Mapping (batch_mapping)

4.2 - Fork

You can use the Fork activity to launch multiple, concurrent activities after the completion of an activity.

5 - Return statuses

5.1 - User Defined Objects Activity

configuration properties “Use return as Status”:

  • enabled then values for return statuses are :
    • 1 - SUCCESS
    • 2 - WARNING
    • 3 - ERROR
  • disabled then value
    • 0 means SUCCESS
    • and non-zero - ERROR.

As a workaround, you can define processflow variable and bind RESULT_CODE parameter of Sql*plus activity to this variable. Then you can define transition from sqlplus activity with custom (“complex”) condition (like PF_VAR_RC=2 etc.).

Advertising

5.2 - Function

Create a function which return as Status to return 1, 2 or 3 to direct the process flow into SUCCESS, WARNING or ERROR respectively.