Before you run a data preview job, verify that there are no mapping validation errors in the selected transformation.
In the Mapping Designer, select a transformation.
Open the
Preview
panel.
Click
Run Preview
.
In the Run Preview wizard, enter the number of source rows to preview and the runtime environment to run the preview job.
The number that you enter applies to each source in the mapping. For example, if you select 10 rows and the mapping contains multiple sources, the preview job processes the first 10 rows in each source.
You can select up to 999,999,999 rows.
Selecting a large number of source rows can cause storage or performance issues on the Secure Agent machine.
Select the
Read Entire Source
option if you're sure you want
Data Integration
to read all source data. Preview data may be slow to display if you have a large source data set. Target data will be limited based on the value entered in the Rows to Preview field.
The
Enable Upstream Preview
option allows you to preview data for the selected transformation and upstream transformations. This option is enabled by default. Preview data may be slow to display if you have many upstream transformations.**
Click
Run Preview
.
Data Integration
displays the results in the
Preview
panel for the selected transformation.
You can monitor preview jobs on the
My Jobs
page in
Data Integration
and on the
All Jobs
and
Running Jobs
pages in Monitor. Data Integration names the preview job <mapping name>-<instance number>, for example, MyMapping_1. You can download the session log for a data preview job.
To restart a preview job, run the job again on the
Preview
panel. You cannot restart a data preview job on the
My Jobs
or
All Jobs
pages.
If you preview data that has parameterized sources or transformations with complex fields on a local cluster, you can only specify an S3/ADLS staging directory.