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:
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:
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:
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.
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:
Step 5. Set Target Options
On the last page of the Debugger Wizard, you can select the following target options:
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:
Using The Designer
Working With Sources
Working With Flat Files
Working With Targets
Mapping Parameters And Variables
Working With User-defined Functions
Using The Debugger
Viewing Data Lineage
Managing Business Components
Creating Cubes And Dimensions
Using The Mapping Wizards
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.