OWB - Operators

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)

• 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

• OWB - Cube
• OWB - Dimension
• Dimensional Operation : OWB - Binding a Relational Table to a Dimensional Object

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:

• 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
• splitter operator
• table_function_operator
• transformation_operator
• unpivot_operator

• Match Merge Operator
• OWB - Name and Adress Operator

Calls a function or procedure before or after executing a mapping

• 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.