ODI Exception Handling

Process:

1.     Create a load Plan scenario

2.     Create Scenarios to an interface - make sure atleast one interface should have error so that we can test

3.     In my case, I am creating one interface as error. (Source to target load -> Selecting IKM Oracle incremental load but there is no primary key in target datastore so that it will error out)

4.     Add Scenario to Load Plan

a.     By default you will have root step

b.     Right click on root step and click on add step à select serial

c.      Drag and drop scenarios from Load plans and scenarios tab on to the serial

d.     Create one procedure which indicate it as error (i.e., create procedure with one task à in target side write a query “Select ‘Error’ from dual” and select appropriate technology as “Oracle” and Logical schema)

e.     Generate scenario for above procedure and drag and drop that scenario into exception tab

·Click on “Plus” Symbol

·Add wizard

·Select Exception

·Name the exception

·Drag and drop the scenario on exception

f.       Select serial step à Go to property inspector à Under exception handling à Exception step , select appropriate exception