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 for a mapping

Running a preview job for a mapping

Run a data preview job on the
Preview
panel of the selected transformation.
Before you run a data preview job for a mapping, verify that the following conditions are true:
  • Verify that a Secure Agent is available to run the job. You can't run a preview job using the Hosted Agent.
  • Verify that the Secure Agent machine has enough disk space to store the preview data.
  • Verify that there are no mapping validation errors in the selected transformation or any upstream transformation.
To run a data preview job:
  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. If the part of the mapping that you are previewing uses input parameters, click
    Next
    and enter the parameter values.
  6. 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.
However, session logs for data preview jobs for mappings in SQL ELT mode aren't available for download.
To restart a preview job, run the job again on the
Preview
panel. You can't restart a data preview job on the
My Jobs
or
All Jobs
pages.

0 COMMENTS

We’d like to hear from you!