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 a preview job in advanced mode

Running a preview job in advanced mode

Run a data preview job on the
Preview
panel of the selected transformation.
Before you run a data preview job, verify that there are no mapping validation errors in the selected transformation.
  1. In the Mapping Designer, select a transformation.
  2. Open the
    Preview
    panel.
  3. Click
    Run Preview
    .
  4. 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.
  5. 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.
  6. 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.**
  7. 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.

0 COMMENTS

We’d like to hear from you!