Designer Guide

10.4.1
- 10.5.6
- 10.5
- 10.4.0

Back Next

Creating Breakpoints

Before you run the Debugger, use the Breakpoint Editor in the Mapping Designer to create breakpoint conditions in a mapping. You can create data or error breakpoints for transformations or for global conditions. When you run the Debugger, the Integration Service pauses the Debugger when a breakpoint evaluates to true. You can review and modify transformation data, and then continue the session.

You cannot create breakpoints for mapplet Input and Output transformations.

A breakpoint can consist of an instance name, a breakpoint type, and a condition. When you enter breakpoints, set breakpoint parameters in the following order:

Select the instance name.
Choose to create a global breakpoint or a breakpoint against a single transformation within the mapping or mapplet.

Select the breakpoint type.
Choose to evaluate error or data conditions. You can also choose the number of rows to skip for the breakpoint type.

Enter the condition.
Enter data conditions for global or transformation data breakpoints. You cannot enter conditions for error breakpoints.

After you set the instance name, breakpoint type, and optional data condition, you can view each parameter in the Breakpoints section of the Breakpoint Editor:

Instance name.
From the Instance Name parameter.

Breakpoint enabled flag.
Enable in the View Breakpoints section.

Breakpoint number.
The Designer assigns a number based on the quantity of breakpoints you create in the mapping. These numbers are sequential. If you remove a breakpoint, the Designer renumbers them when you close and reopen the Breakpoint Editor.

Breakpoint type.
From the Breakpoint Type section.

Number of rows to skip.
From the Breakpoint Type section.

Data condition.
From the Condition section.

The following figure shows the parameters in the Breakpoints section:

The Breakpoints section displays global breakpoints and breakpoints for the Lookup and Aggregator transformations.

For the Lookup transformation, LKP_Store, the check indicates the breakpoint is enabled. “#2” is the sequential breakpoint number, “Data” indicates the breakpoint type, “0” indicates the number of breakpoint rows to skip, and “STORE_ID=[2641]” is the data condition.

Using the Debugger

Selecting the Instance Name

Creating Error Breakpoints

Creating Data Breakpoints

Entering the Data Breakpoint Condition

Steps to Enter Breakpoints

Editing a Breakpoint

Download Guide

Watch

Comments

Communities

Knowledge Base