Table of Contents

Search

  1. Preface
  2. Mappings
  3. Mapping tutorial
  4. Parameters
  5. CLAIRE recommendations
  6. Data catalog discovery

Mappings

Mappings

SQL ELT query preview

SQL ELT query preview

When you create a mapping that is configured for SQL ELT optimization or a mapping in SQL ELT mode, you can preview the SQL queries that
Data Integration
pushes to the database or cloud data warehouse. Preview these queries in the
SQL ELT Query
panel in the Mapping Designer.
You can preview SQL ELT queries for some connector types. For more information, see the help for the appropriate connector.
When you preview SQL ELT queries,
Data Integration
creates and runs a temporary SQL ELT preview mapping task. When the job completes,
Data Integration
displays the SQL to be executed and any warnings in the
SQL ELT Query
panel.
The following image shows the
SQL ELT Query
panel:
The image shows the SQL ELT Query panel on the right side of the Mapping Designer. The panel shows that there are no warnings in the General Warnings area. Group 1 is expanded and shows the SQL query to be executed.
For mappings that are configured for SQL ELT optimization,
Data Integration
groups SQL and warnings based on the data flow run order. After you run the SQL ELT preview job, you can preview the data after it's transformed by the transformations included in the SQL queries.
If the SQL ELT optimization type that you select isn't available,
Data Integration
lists the SQL queries, if any, that can be executed. For example, if you select Full SQL ELT optimization, but the target doesn't support it,
Data Integration
displays the SQL queries that will be pushed to the source.
You can't preview SQL ELT queries in advanced mode.

0 COMMENTS

We’d like to hear from you!