ODI Truncate Table in a Package
ODI 11.1.1.7.0 with BI Apps 11.1.1.8.1
I needed to do a Truncate Table in a Package.
Here is how I did it and this works for me in the
case of my ODI Load of a BI Apps.
This should work for any version of ODI.
Step 1
Create a New ODI Procedure
Step 2
Add a new command in the Details Side Table
Step 3
Command to Truncate Table in a Procedure which goes into a Package
In the Command on Target Tab. Add this command:
TRUNCATE TABLE <%=snpRef.getObjectName("L","WC_OBJECTIVE_F_DEL","D")%> DROP STORAGE
Replace the WC_OBJECTIVE_F_DEL with the name of your table
you wish to Truncate.
Step 4
Do not modify, leave the Command on Source blank (empty)
Step 5
Drag and drop the Procedure you just
created into the package and connect it.
Save the package and your done!
;)
;)
;)
;)
;)
