To preview the data, you must have the Data Integration Data Previewer role or your user role must have the "Data - preview" feature privilege for

Data Integration

.

When you run an SQL ELT query preview,

Data Integration

creates a temporary mapping task that contains a virtual target immediately before the target or the last transformation possible for SQL ELT optimization.

When you run SQL ELT query data preview,

Data Integration

runs a data preview job using the parameter values and session attributes that you entered when you configured the SQL ELT query preview job. The transformation that

Data Integration

runs data preview on depends on the type of SQL ELT optimization that is possible.

The following table describes the transformation that data preview runs on for each type of optimization:

Optimization type	Transformation
Full	Transformation immediately before the Target transformation.
Partial	Last transformation where SQL ELT optimization is possible.

You can't preview SQL ELT query data for the following transformations:

Data Masking
Hierarchy Builder
Router
Sequence Generator
Velocity
Web Services
Target

You can't preview SQL ELT query data for a mapping if the last transformation where SQL ELT optimization is possible is a Mapplet transformation. You can't preview the data for mappings in SQL ELT mode.

If you run an SQL ELT query data preview job at the same time you run a mapping data preview job in the same mapping, the job fails.