Configuring the Debugger - Informatica

In addition to setting breakpoints, you must also configure the Debugger. Use the Debugger Wizard in the Mapping Designer to configure the Debugger against a saved mapping. When you configure the Debugger, enter parameters such as the Integration Service, source and target type, and memory parameters. You must enable debugging in the Integration Service configuration before you use it to run the Debugger.

The Debugger Wizard has the following pages:

  1. Introduction.This page gives you an overview of the wizard. You do not configure any properties on this page.
  2. Integration Service and session type. Choose the Integration Service to run the session. You can also choose to run the Debugger against an existing non-reusable session, an existing reusable session, or create a debug session instance. When you run the Debugger against an existing session, the Integration Service runs the session in debug mode. When you create a debug session, you configure a subset of session properties within the Debugger Wizard, such as source and target location.
  3. Session information. If you run the Debugger against an existing session, select the session name. If you create a debug session, configure session parameters.
  4. Session configuration. If you create a debug session, set the session configuration.
  5. Target options. Choose to load or discard target data.

Step 1. Debugger Introduction

The first page of the Debugger Wizard provides an overview of the wizard.

Step 2. Select Integration Service and Session Type

On the second page, you can select the following options:

  • Integration Service to run the session. The list displays all Integration Services associated with the repository.
  • Choose an Integration Service that has debugging enabled.
  • Run the Debugger against an existing non-reusable session, an existing reusable session, or create a debug session instance. If you want to debug a mapping that uses session properties, such as incremental aggregation, FTP, or pre- or post-session commands, you must run an existing session in debug mode.

When you click Next, the Designer tests the connection to the Integration Service and verifies that debugging is enabled for the Integration Service. If the connection fails, the Designer prompts you to select another Integration Service.

Step 3. Select Session Information

The page that the wizard displays for session information depends on whether you choose to run a debug session or an existing session in debug mode.

Running an Existing Session in Debug Mode

If you choose to run an existing session in debug mode, the Debugger Wizard displays a list of all sessions in the current folder that use the mapping. Select the session you want to use.

You cannot run the Debugger against a session configured with multiple partitions or a session configured to run on a grid. You must either change the properties of the session or choose to create a debug session for the mapping.

Running a Debug Session

If you choose to run a debug session, you can specify some session parameters. The Debugger uses default session parameters for all other parameters that you cannot configure with a debug session. The Debugger Wizard displays a session page that contains the following tabs:

  • Connections.Select source and target connection information.
  • For relational sources and targets, you can select a database connection that is configured in the Workflow Manager. For relational targets, you can choose to truncate the target tables.

    For file sources and targets, you can /override the file name. The default locations are $SourceFileDir and $TargetFileDir. To override the default location for a source or target file, use the Session Parameters tab. Do not enter the direct path in the file name field.

  • Properties.Configure source and target properties.
  • Reader/Writer.Configure readers and writers for the source and target instances in the mapping.

When you run a debug session, the Integration Service uses default session properties for all properties that you do not configure in the Debugger Wizard.

You can select source and target connections for each source and target instance in the debug session on the Connections tab.

You can choose the source reader type and target writer type for each source and target instance in the debug session on the Reader/Writer tab.

The Properties tab displays different source and target properties depending on the type of reader or writer you select on the Reader/Writer tab. The Integration Service uses default values for all session properties you do not configure on the Properties tab. You can configure session properties for the Debug session.

Step 4. Set Session Configuration

When you set the debug session configuration, you configure information such as the location of files, row type, and memory. The following table describes the session parameters for a debug session:

Set Session Configuration

Step 5. Set Target Options

On the last page of the Debugger Wizard, you can select the following target options:

  • Discard target data. You can choose to load or discard target data when you run the Debugger. If you discard target data, the Integration Service does not connect to the target.
  • Display target data. You can select the target instances you want to display in the Target window while you run a debug session.

When you click Finish, if the mapping includes mapplets, the Debugger displays the mapplet instance dialog box. Select the mapplets from this dialog box that you want to debug. To clear a selected mapplet, press the Ctrl key and select the mapplet.

When you select a mapplet to debug, the Designer expands it to display the individual transformations when the Debugger runs.

When you do not select a mapplet to debug, the Designer does not expand it in the workspace. You cannot complete the following tasks for transformations in the mapplet:

  • Monitor or modify transformation data.
  • Evaluate expressions.
  • Edit breakpoints.
  • Step to a transformation instance.

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

Informatica Topics