OWB - Operators

About

The operators are used in a mapping to create a process and have several types :

• Source/Target Operators: These operators represent Oracle Database objects in the mapping. It also contains Flat File Source and Target operators.
• Remote and Non Oracle Source and Target Operators
• Data Flow Operators: Data flow operators transform data.
• Pre/Post Processing Operators: Calls a function or procedure before or after executing a mapping
• Pluggable Mapping Operators: These are mappings that function as operators in other mappings.

As you can have by type the same properties, I have create a Properties section (Just for convenience)

Articles Related

Source and Target Operators

• OWB - Constant Operator
• Construct Object Operator
• Data Generator Operator
• OWB - External Table
• Expand Object Operator
• OWB - Materialized View
• Sequence
• OWB - Table
• Varray Iterator Operator
• OWB - View

Dimensional operator

• OWB - Cube
• OWB - Dimension
• Dimensional Operation : Binding

Data Flow Operators

These operators enable you to define common transformations that specify how data moves from the source to the target.

The list of data flow operators is as follows:

• OWB - Aggregator operator
• Anydata Cast Operator
• Deduplicator Operator
• Expression Operator
• Filter Operator
• OWB - Joiner operator
• OWB - Key lookup operator
• Pivot Operator
• Set Operation Operator
• Sorter Operator
• OWB - splitter operator
• Table Function Operator
• Transformation Operator
• Unpivot Operator

Data Quality Operators

• OWB - Match Merge Operator
• OWB - Name and Adress Operator

Pre/Post Processing Operators

Calls a function or procedure before or after executing a mapping

• OWB - Pre-mapping process operator : Calls a function or procedure prior to executing a mapping.
• Post Mapping Process Operator : Calls a function or procedure after executing a mapping.
• Mapping input parameter operator : Passes parameter values into a mapping.
• Mapping output parameter operator : Sends values out of a mapping.