Search code examples
unit-testingetlinformatica-powercenter

Can I unit test Informatica Powercentre workflows?

Can I unit test Informatica Powercentre workflows?

EDIT: More specifically, can I mock sources and target and test the steps in between? Eg. If I have a workflow with a Oracle source and a text file target can I test it without Oracle and a text file.?

Solution

  • No you can't.

    When you create and save a mapping Informatica validates if the mapping is syntactically valid. It will give you an error message if it's not. Look for the errors in the bottom panel. You can validate a mapping by going to Mappings Menu > Validate.

    You can validate a workflow similarly : Workflows Menu > Validate.

    To run the workflow it is necessary that you have the source and target available and connected. If you don't want to write to target or don't want to do full volume testing you can use "Enable Test Load" at the Session level (Edit > Properties > Enable Test Load) and set "Number of rows to test".