Configuring a Saved Query

1. Click Configure > Saved Queries.
2. On the Saved Queries page, click New.
3. On the New Saved Query page, enter the following information:

Saved Query Field	Description
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.
Description	Description of the saved query. Maximum length is 255 characters.
Database Type	Source database type. Select one of the following database types: - Salesforce - Oracle - SQL Server - MySQL - ODBC - MS Access
SQL Query	Enter a valid SQL statement to select the source columns you want to use.

4. Click Get Columns.
5. In the Get Columns dialog box, select a connection.
The Saved Query Column Details table displays the source columns selected in the SQL statement. In the table, the Info column displays a summary of information about the column. Type displays the datatype for the column.
6. In the Saved Query Column Details table, you can edit the datatype, precision, or scale.
If you edit these values, Informatica Cloud does not write error rows into the error rows file.
7. To change all source column information, enter another SQL statement and click Get Columns.
Informatica Cloud deletes all information in the Saved Query Column Details table, and then retrieves column information based on the latest SQL statement.
You can edit the datatype, precision, or scale of the columns.
8. Click OK.