Database Reference
In-Depth Information
Debug me please - the debugger
Informatica PowerCenter provides a utility called debugger that debugs the mapping so that
you can easily find issues with the mapping that you created. Using the debugger, you can
see the flow of every record across the transformations.
As you are aware, Informatica PowerCenter is not a data storage tool, it is a data manipula-
tion tool that helps you manipulate the data. This point is important to the debugger, as
once you finish the process, you only have either the source or the target to check the result
and compare it in order to verify the data. Debugger jumps in with a functionality that
provides you with the option to actually see the data flow from each and every transforma-
tion in your mapping.
When you execute the mapping through the session task, the data automatically starts flow-
ing from the source to the target through transformations. You manually execute the same
process using the debugger.
Take a look at the upcoming example to understand the debugger functionality.
You created a mapping with 100 transformations, and you have 1,000 records present in
your source. You executed the mapping and got the results. When you started analyzing the
output in your target table, you found that the data in few columns was incorrect. Now, the
problem is that you are not sure where out of the 100 transformations the issue actually
started— debugger is your solution. It will allow you to see the movement of each record
from every transformation so that you can catch the origin of the error and rectify it accord-
ingly.
To set up and execute the debugger, perform the following steps:
1. In the designer, navigate to
Tools
|
Mapping Designer
|
Mapping
|
Debugger
|
Start Debugger
, as shown in the following screenshot:
