Design > Saved Queries > Configuring a Saved Query
  

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.
    Description
    Description of the saved query.
    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.