Creating an ODI Procedure

Create new project

Switch to the Designer Navigator. Click the Designer tab. Select the Projects tab, click the New Project icon, and select New Project.

Enter the name of the project: Procedure-CRT-TBL. Click the Save button to create the project and close the tab. The project appears in the tree view. Expand the Procedure-CRT-TBL project node.




Open ODI Designer. In the Projects tab, select Procedure-CRT-TBL > First Folder. Right-click Procedures and select New Procedure.

Enter the procedure name as PRD-create-populate-table. Set Target Technology to Oracle. Click the Details tab. Click the icon  to add a step in the procedure.




New window, enter the parameters

Select the Ignore Errors check box.



Select the Details tab, and then click the icon to add another step in the procedure ”CREATE TABLE”

 

Click the Details tab. Click the icon  to enter the step to populate the SRC_SALES_PERSON table.



Click Save and close the tab.
 

 

Execute It
In ODI Operator