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

Data preview in mappings

Data preview in mappings

When you create a mapping, you can preview data for individual transformations to test the mapping logic.
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:
The mapping contains Source, Filter, Sorter, and Target transformations. The Sorter transformation is selected, and the Preview panel is displayed. The Preview panel shows the rows of data that have been processed by the Filter and Sorter transformations.
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.

0 COMMENTS

We’d like to hear from you!