Cloud Data Integration All Products
Saved Query Name
Name of the saved query.
Query names can contain alphanumeric characters, spaces, and the following special characters: _ . + -
Maximum length is 100 characters. Query names are not case sensitive.
Location of the saved query. Browse to the folder where you want to store the saved query or use the default location.
Explorepage is currently active and a project or folder is selected, the default location for the asset is the selected project or folder. Otherwise, the default location is the location of the most recently saved asset.
Description of the saved query.
Maximum length is 255 characters.
Source database type. Select one of the following database types:
To use the query in an SQL transformation, the database type must be Oracle or SQL Server.
SQL statements that make up the SQL query.
To use the query as the source in a
synchronizationtask, enter a SELECT statement.
Data Integrationuses the SELECT statement to retrieve the source column information.
To use the query in an SQL transformation, enter one or more valid SQL statements. Do not use SQL transformation parameter binding or string substitution notation in the query because saved queries have no information about SQL transformation input fields.