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

JDBC Sources in Mappings

When you configure a mapping to use a JDBC source, you can configure the source properties.
Specify the name and description of the JDBC source. Configure the source and advanced source properties for the JDBC object.
The following table describes the JDBC source properties:
Property
Description
Connection Name
Name of the source connection.
Source Type
Source type. Select one of the following types:
  • - Single. Select to specify a single JDBC object.
  • - Multiple. Select to specify multiple JDBC objects. You must specify the source object, related source object, and configure the relationship between the source objects. Related objects appear based on simple primary key or composite keys object relationship.
  • - Parameter. Select to specify a parameter name. You can configure the source object in a Mapping Configuration task associated with a mapping that uses this source transformation.
Object
Source object for the mapping.
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.
The following table describes the JDBC advanced source properties:
Advanced Source Property
Description
Page Size
Number of rows that are cached from a JDBC source. Default is 1000.
Isolation Level
Determines the level of concurrency in transactions to avoid data inconsistency. Select from the following isolation levels:
  • - None
  • - TRANSACTION READ COMMITTED
  • - TRANSACTION READ UNCOMMITTED
  • - TRANSACTION REPEATABLE READ
  • - TRANSACTION SERIALIZABLE
Default is None.
Override Isolation Level
Overrides the isolation level if the database does not support it. If this option is checked, the task runs successfully with the default isolation level of the database.
Number of Rows to be Fetched
Number of rows that are read from a JDBC source. Specify the number of rows fetched to limit the data retrieved. Default is zero, which indicates that an unlimited number of rows are fetched.
Tracing Level
Sets the amount of detail that appears in the log file. You can choose terse, normal, verbose initialization or verbose data. Default is normal.