You preview data for a transformation on the

Preview

panel of the transformation. Select the number of source rows to process and the runtime environment that runs the preview job.

When you run a preview job,

Data Integration

creates a temporary mapping task that contains a virtual target immediately downstream of the selected transformation.

Data Integration

discards the temporary task after the preview job completes. When the job completes,

Data Integration

displays the data that is transformed by the selected transformation on the

Preview

panel.

The following image shows the

Preview

panel of a Sorter transformation after you run a preview job on the transformation:

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

Data Integration

.

If you apply a limit to the number of rows to preview for an active transformation, such as a Filter transformation, that row limit also applies to the source. The Filter transformation might show fewer rows output in the filter preview window than in the source preview window, depending on the filter condition.

You can preview data if the mapping uses input parameters.

Data Integration

prompts you for the parameter values when you run the preview.

You can't preview data when you develop a mapplet in the Mapplet Designer. You can't preview data that contains special, emoji, and Unicode characters in the table name.