Transformations > Source Transformation > Database Source Properties
  

Database Source Properties

You can configure properties for database sources.
The following table describes the database source properties:
Database Property
Description
Connection
Name of the source connection.
Source Type
Source type.
Object
Source object for a single source.
Add Source Object
Primary source object for multiple sources.
Add Related Objects
For multiple sources. Displays objects related to the selected source object.
Select an object with an existing relationship or click Custom Relationship to create a custom relationship with another object.
Filter
Adds conditions to filter records. Configure a simple or an advanced filter.
Sort
Adds conditions to sort records.
Select Distinct Rows Only
Reads unique rows from the source. Adds SELECT DISTINCT to the SQL query.
Define Query
For a custom query. Displays the Edit Custom Query dialog box. Enter a valid custom query and click OK.