Friday 22 April 2016

Exceptions Handling in ODI 11g.

Exceptions Handling in ODI

When we need to send a notification after failure of our load plan ! how we will configure it in ODI.

We can use Exception Handling in ODI 11g.

After setting the load plan we can configure Exception Handling in ODI.

  • Double click on Load Plan then select Exceptions.

  • From the add Button add Exception Step to your load Plan.



  • After this drag your Scenario step created for exception(In this case i created a procedure for failure mail)



  • Now click on your root step in load plan. From Property tab select  Exception Behavior as Run Exception and Raise.




  •  Now you are good to go with the Load Plan. If any error occurred while executing this load plan the exception step will work and you will get the failure mail. 

Thank You.