Sunday, 22 February 2015

How to work with Informatica Debugger

While loading data through Informatica, some time we come across situations where data is not loaded properly to the Target as per the transformation logic set. if you could track the data flowing from Source to Target then come to know where went wrong.
Use of Debugger:-
  1. Informatica Debugger is useful for testing and tracking errors in Informatica in run time.
  2. The data flow can be checked at each transformation level and can be modified for testing and analyzing
  3. Any valid mapping can be debugged to gain troubleshooting information about data and error conditions.
  4. No More Dummy Data / Flat Files are required for testing mapping
Debugger Session Types:
  • There are 3 types of Debugger Sessions
  • Debugger runs a workflow for each session type
    • Using an existing non-reusable session
    1. Existing source, target, and session configuration properties used
    2. The Integration Service runs the non-reusable session in the existing workflow
    3. The Debugger does not suspend on error
    4. Existing source, target, and session configuration properties used.

No comments:

Post a Comment