Debugger is an integral part of Informatica Power Center mapping designer, which help you in troubleshooting the ETL logical error or data error conditions in an Informatica mapping. The debugger user interface shows the step by step execution path of a mapping and how the source data is transformed in the mapping.
To configure debugger window open Mapping tab and select debugger option from the Menu bar (or) press F9
The pop up window comes to select Integration services and Session type to use
The data for the target tables can either be discarded or written to the target location. If data is discarded, we can still view the data row by row while the mapping is running.
Below figure shows the windows in the Mapping Designer, that appears when you run the Debugger
The debugger user interface is integrated with Mapping Designer. Once you invoke the debugger, you get few additional windows to display the debugging information such as transformation instance window to show how the data is transformed at a transformation instance and target window to show what data is written to the target.
- Instance Window: View how data is transformed at a transformation instance, this window gets refreshed as the debugger progresses from one transformation to other. You can choose a specific transformation from the drop down list to see how data looks like at that particular transformation instance for a particular source row.
- Target Window: Shows what data is processed into the target instance. You can see, if the record is going to get inserted, updated, deleted or rejected. If there are multiple target instances, you can choose the target instance name from the drop down window, to see its data.
- Mapping Window: Mapping window shows the step by step execution path of a mapping. It highlights the transformation instance which is being processed and shows the breakpoints setup on different transformations.
- Debugger Log: This window shows messages from the Debugger.
Click on Next instance from debugger options (or) press F10
And we can the instance window with currently running transformation, rowed continue with next transformation with F10.
Here we can see the target window with o/p comes as row by row whenever Rowid changes.
When the Debugger pauses, you can use the Expression Editor to evaluate expressions using mapping variables and ports in a selected transformation. This option is helpful to evaluate and rewrite an expression, in cause if you find the expression result is wrong.
We can access Evaluate Expression window from Mapping -> Debugger -> Evaluate Expression.
When the Debugger pauses, the current instance displays in the Instance window. We can make the data modifications to the current instance when the Debugger pauses on a data break point.
We can modify the data from the instance Window. This option is helpful, if we want to check what would be the result if the input was any different from the current value.