Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Truncate table ODI procedure

choracy69Nov 21 2018 — edited Nov 21 2018

Hi,

I want tu create procedure in ODI 12c like Truncate_Table.

I have Datastore: OR.SRC_450 ---> in database I have table OR.SRC_450

Next I want create universal procedure in ODI to truncate table something like: TRUNCATE TABLE <getObjectName> and next create package for example for this table: SRC_450--------> TruncateTable

How can I do this? How write procedure in ODI that it take table name from datastore in package?

Added on Nov 21 2018

#business-intelligence-applications, #data-integrator, #system-management-and-integration

2 comments

1,545 views