1 / 60

Testing & Debugging in Informatica PowerCenter

Testing & Debugging in Informatica PowerCenter. Agenda. What do we test in Informatica ? Preparing to test Different types of problems Solutions to problems Using the debugger Where to look for problem causes Common problems and their solutions. Testing – What needs to be tested?.

stefanie-stephanie
Download Presentation

Testing & Debugging in Informatica PowerCenter

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Testing & Debugging in Informatica PowerCenter

  2. Agenda • What do we test in Informatica? • Preparing to test • Different types of problems • Solutions to problems • Using the debugger • Where to look for problem causes • Common problems and their solutions

  3. Testing – What needs to be tested? • Format Examples: • File length • Number formats • Representation of NULL • Logic Examples: • Calculation results • Results of logical conditions

  4. Testing – Preparing for battle • Prepare test plan • Grant appropriate file permissions • Prepare test data

  5. Types of problems • Format related “What is this junk data?!!!” ”My file looks ugly!!” • Logic related “Why am I getting a different output? I am SURE my logic is correct” • Others • Workflow fails • No session log written

  6. Fighting it out… • Format related problems Solution: • File length – Check port length/precision • Number formats – Check port length/precision • Representation of NULL – check session properties

  7. Fighting it out… • Logic related problems Solution:Debugger!!!!!

  8. Features in the Debugger • Setting break points • Evaluating expressions • Discarding target data

  9. Using the Debugger

  10. Fighting it out… • Other problems

  11. Where to look? • Session property in Workflow monitor • Session log • Session property in Workflow designer • Debugger

  12. Accessing the session property in Workflow monitor

  13. Accessing the session Log file in Workflow monitor

  14. Changing the logging to ‘verbose’ mode

More Related