OWB - Process Flow
> Data Integration Tool (ETL/ELT) > Oracle Warehouse Builder
Table of Contents
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).
2 - Articles Related
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.).
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.