Table of Contents

Search

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

Mappings

Mappings

Running an SQL ELT query preview for mappings configured for SQL optimization

Running an SQL ELT query preview for mappings configured for SQL optimization

Preview the SQL queries that
Data Integration
pushes to the database on the
SQL ELT Query
panel.
Before you run an SQL ELT query preview, verify that the following conditions are true:
  • In-out parameters have a default value. You can't provide values for in-out parameters when you configure the preview job.
  • The mapping is valid.
To run an SQL ELT query preview for a mapping that is configured for SQL optimization:
  1. Open the
    SQL ELT Query
    panel.
  2. Click
    Generate SQL Query
    .
  3. In the
    SQL ELT Preview
    wizard, select the runtime environment and then click
    Next
    .
  4. If the mapping contains input parameters, enter the parameter values and then click
    Next
    .
  5. Configure SQL ELT optimization options.
  6. Click
    SQL ELT Preview
    .
Data Integration
displays the SQL queries and any warnings in the
SQL ELT Query
panel. If a warning relates to a transformation, click the warning to select the transformation on the mapping canvas. If SQL ELT optimization fails,
Data Integration
lists any queries generated up to the point of failure.
To view the transformations included in SQL ELT optimization, click
View Transformations
for the group you want to view. To highlight the group on the mapping canvas, click
Highlight
for the group you want to see.
You can monitor preview jobs on the
My Jobs
,
Running Jobs
, and
All Jobs
pages.
Data Integration
names the job <mapping name>_sql_elt_preview-<instance number>, for example, Mapping1_sql_elt_preview-2. You can download the session log for the preview job.
If you update the mapping after you run the preview job, the preview is no longer valid. To restart a preview job, run it again from the
SQL ELT Query
panel. You can't restart the job from the
My Jobs
,
Running Jobs
, or
All Jobs
page.

0 COMMENTS

We’d like to hear from you!