Table of Contents

Search

  1. Preface
  2. Components
  3. API collections
  4. Business services
  5. File listeners
  6. Fixed-width file formats
  7. Hierarchical schemas
  8. Intelligent structure models
  9. Refining intelligent structure models
  10. Mapplets
  11. Saved queries
  12. Shared sequences
  13. User-defined functions

Components

Components

Using saved queries in SQL transformations

Using saved queries in SQL transformations

Configure an SQL transformation to use a saved query on the
SQL
tab of the
Properties
panel. You can use one saved query in an SQL transformation.
  1. On the
    SQL
    tab of the
    Properties
    panel, select the connection that contains the tables that you want to run the query against.
  2. Set the SQL type to
    SQL Query
    .
  3. Set the query type to
    Saved Query
    .
  4. Select the saved query that you want the SQL transformation to process.
For more information about SQL transformations, see
Transformations
.

0 COMMENTS

We’d like to hear from you!