debugging in informatica

7/28/2019 Debugging in Informatica

1/5

overview

You can debug a valid mapping to gain troubleshooting information about data and errorconditions. To debug a mapping, you configure and run the Debugger from within the Mapping

Designer. The Debugger uses a session to run the mapping on the Integration Service. When you

run the Debugger, it pauses at breakpoints and you can view and edit transformation output data.

You might want to run the Debugger in the following situations:

Before you run a session. After you save a mapping, you can run some initial tests with adebug session before you create and configure a session in the Workflow Manager.

After you run a session. If a session fails or if you receive unexpected results in thetarget, you can run the Debugger against the session. You might also want to run the

Debugger against a session if you want to debug the mapping using the configured

session properties.

Debugger Session Types

You can select three different debugger session types when you configure the Debugger. The

Debugger runs a workflow for each session type. You can choose from the following Debugger

session types when you configure the Debugger:

Use an existing non-reusable session. The Debugger uses existing source, target, andsession configuration properties. When you run the Debugger, the Integration Service

runs the non-reusable session and the existing workflow. The Debugger does not suspend

on error.

Use an existing reusable session. The Debugger uses existing source, target, and sessionconfiguration properties. When you run the Debugger, the Integration Service runs adebug instance of the reusable session and creates and runs a debug workflow for the

session.

Create a debug session instance. You can configure source, target, and sessionconfiguration properties through the Debugger Wizard. When you run the Debugger, the

Integration Service runs a debug instance of the debug workflow and creates and runs a

debug workflow for the session.

Debug Process

To debug a mapping, complete the following steps:

1. Create breakpoints. Create breakpoints in a mapping where you want the IntegrationService to evaluate data and error conditions.

2. Configure the Debugger. Use the Debugger Wizard to configure the Debugger for themapping. Select the session type the Integration Service uses when it runs the Debugger.When you create a debug session, you configure a subset of session properties within the

Debugger Wizard, such as source and target location. You can also choose to load or

discard target data.


2/5

3. Run the Debugger. Run the Debugger from within the Mapping Designer. When yourun the Debugger, the Designer connects to the Integration Service. The Integration

Service initializes the Debugger and runs the debugging session and workflow. The

Integration Service reads the breakpoints and pauses the Debugger when the breakpointsevaluate to true.

4.

Monitor the Debugger. While you run the Debugger, you can monitor the target data,transformation and mapplet output data, the debug log, and the session log. When yourun the Debugger, the Designer displays the following windows:

o Debug log. View messages from the Debugger.o Target window.View target data.o Instance window.View transformation data.

5. Modify data and breakpoints. When the Debugger pauses, you can modify data and seethe effect on transformations, mapplets, and targets as the data moves through the

pipeline. You can also modify breakpoint information.

The Designer saves mapping breakpoint and Debugger information in the workspace files. You

can copy breakpoint information and the Debugger configuration to another mapping. If youwant to run the Debugger from another PowerCenter Client machine, you can copy the

breakpoint information and the Debugger configuration to the other PowerCenter Clientmachine.

The following figure shows the windows in the Mapping Designer that appears when you run the

Debugger:


3/5

1. Debugger log.2. Session log.3. Instance window.4. Target window.

BREAK POINT IN DEBUGGER ? ?

Hi Prasad,

Hope below given information can be helpful to you:

BreakPoint-You can debug a valid mapping to gain troubleshooting information about data and

error conditions. To debug a mapping, you configure and run the Debugger from within the
https://community.informatica.com/message/75344#75344https://community.informatica.com/message/75344#75344https://community.informatica.com/message/75344#75344


4/5

Mapping Designer. The Debugger uses a session to run the mapping on the Integration Service.

When you run the Debugger, it pauses at breakpoints and you can view and edit transformation

output data.

You might want to run the Debugger in the following situations:

1. Before you run a session. After you save a mapping, you can run some initial tests with adebug session before you create and configure a session in the Workflow Manager.

2. After you run a session. If a session fails or if you receive unexpected results in the target,

you can run the Debugger against the session. You might also want to run the Debugger against asession if you want to debug the mapping using the configured session properties.

When you add breakpoint to a debugger-The Debugger runs from within the Mapping Designer.Then the Designer connects to the Integration Service. The Integration Service initializes the

Debugger and runs the debugging session and workflow. The Integration Service reads the

breakpoints and pauses the Debugger when the breakpoints evaluate to true.

We can set as many breakpoints in the debugger depending upon our requirements.

Basically While you run the Debugger, you can monitor the target data, transformation andmapplet output data, the debug log, and the session log. When you run the Debugger, the

Designer displays the following windows:

Debug log. View messages from the Debugger.,

Target window. View target data.

Instance window. View transformation data.


5/5

When the Debugger pauses, you can modify data and see the effect on transformations,

mapplets, and targets as the data moves through the pipeline. You can also modify breakpoint

information.

Please refer the image attched hereby for better understanding.

Let em know if this helps.
https://community.informatica.com/servlet/JiveServlet/showImage/2-75344-2842/Debugger.jpg

debugging in informatica

Documents