Skip to Main Content

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!

ODI Truncate vs Delete All

dilekJan 22 2014 — edited Jan 22 2014

Hello everyone,

My mapping(interface) runs everyday and, aim is deleting all records and load the new data for a few months period. At this situation, which option should I use in the knowledge module? Should I truncate the exsiting table, and creat e again or only delete all records in it? Which is better in terms of performance?

Thank You

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 19 2014
Added on Jan 22 2014
4 comments
882 views