Table of Contents

Search

  1. Preface
  2. Part 1: Introduction to Amazon Redshift connectors
  3. Part 2: Data Integration with Amazon Redshift V2 Connector
  4. Part 3: Data Integration with Amazon Redshift Connector

Amazon Redshift Connectors

Amazon Redshift Connectors

Previewing SQL ELT optimization

Previewing
SQL ELT optimization

Before you can run a mapping task configured for
SQL ELT optimization
, you can preview if
SQL ELT optimization
is possible when you create the mapping. You can preview
SQL ELT optimization
from the
SQL ELT optimization
panel in the Mapping Designer.
After you select the required
SQL ELT optimization
options and run the preview,
Data Integration
creates and runs a temporary SQL ELT preview mapping task. When the job completes,
Data Integration
displays the SQL queries to be executed and any warnings in the
SQL ELT Optimization
panel. The warning messages help you understand which transformations in the configured mapping are not applicable for
SQL ELT optimization
. If
SQL ELT optimization
fails, Data Integration lists any queries generated up to the point of failure. You can edit the mapping and fix the required transformations before you run the mapping for
SQL ELT optimization
.
You can also view the temporary job created under
My Jobs
and download the session log to view the queries generated.
For more information about how to preview
SQL ELT optimization
, see the topic "
SQL ELT optimization
preview" in
Mappings
in the Data Integration help.

0 COMMENTS

We’d like to hear from you!