Table of Contents

Search

  1. Preface
  2. Components
  3. Business services
  4. File listeners
  5. Fixed-width file formats
  6. Hierarchical schemas
  7. Intelligent structure models
  8. Mapplets
  9. Saved queries
  10. Shared sequences
  11. 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
.


Updated August 03, 2020