To use a custom query as a source, select

Query

as the source type and then click

Select

. When you define the query, use SQL that is valid for the source database. You can use database-specific functions in the query.

When you create a custom query, enter an SQL SELECT statement to select the source columns you want to use.

Data Integration

uses the SQL statement to retrieve source column information.

Data Integration

ensures that custom query column names are unique. If an SQL statement returns a duplicate column name,

Data Integration

adds a number to the duplicate column name as follows:

<column_name><number>