Oracle Connector Guide > Mappings and Mapping Configuration Tasks with Oracle Connector > Oracle Sources in Mappings
  

Oracle Sources in Mappings

To read data from an Oracle database, configure an Oracle object as the Source transformation in a mapping.
Enable partitioning when you configure the Source transformation in the Mapping Designer to optimize the performance of the Mapping Configuration task.
Specify the name and description of the Oracle source. Configure the source, query options, and advanced properties for the source object.
The following table describes the properties that you can configure for an Oracle source:
Property
Description
Connection
Name of the active source connection.
Source Type
Type of the Oracle source object available. You can choose from the following source types:
  • - Single
  • - Multiple
  • - Query
  • - Parameter
Object
Name of the source object for the mapping.
You can specify a custom query for a source object.
Filter
Configure a simple filter or an advanced filter to remove rows at the source. You can improve efficiency by filtering early in the data flow.
A simple filter includes a field name, operator, and value. Use an advanced filter to define a more complex filter condition, which can include multiple conditions using the AND or OR logical operators.
Sort
Select the fields and type of sorting to use. To sort data for a parameterized source, you must use a parameter for the sort options.
Select distinct rows only
When you read data from multiple sources, select this option to read only distinct rows.
The following table describes the advanced properties that you can configure for an Oracle source:
Advanced Property
Description
Tracing Level
Amount of detail that appears in the log for this transformation. You can choose terse, normal, verbose initialization, or verbose data. Default is normal.
Pre SQL
Pre-SQL command that must be run before reading data from the source.
Post SQL
Post-SQL command that must be run after writing data to the target.
Output is deterministic
Relational source or transformation output that does not change between session runs when the input data is consistent between runs.
When you configure this property, the Secure Agent does not stage source data for recovery if transformations in the pipeline always produce repeatable data.
Output is repeatable
Relational source or transformation output that is in the same order between session runs when the order of the input data is consistent.
When output is deterministic and output is repeatable, the Secure Agent does not stage source data for recovery.