610 likes | 797 Views
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?.
E N D
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? • Format Examples: • File length • Number formats • Representation of NULL • Logic Examples: • Calculation results • Results of logical conditions
Testing – Preparing for battle • Prepare test plan • Grant appropriate file permissions • Prepare test data
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
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
Fighting it out… • Logic related problems Solution:Debugger!!!!!
Features in the Debugger • Setting break points • Evaluating expressions • Discarding target data
Fighting it out… • Other problems
Where to look? • Session property in Workflow monitor • Session log • Session property in Workflow designer • Debugger