Is It Possible To Re-use The Same Temporary (flow) Tables In ODI?
(Doc ID 2706136.1)
Last updated on MAY 31, 2024
Applies to:
Oracle Utilities Advanced Spatial and Operational Analytics - Version 2.7.0.0.10 and laterInformation in this document applies to any platform.
Goal
On : 2.7.0.0.10 version, Install / Upgrade
Is it possible to re-use the same temporary (flow) tables in ODI?
Right now OUA creates a lot of temporary tables as part of each mapping run. Too many DDL operations are affecting the DB performance.
Is it possible to re-use those temp tables with truncate insert method instead of creating new flow tables for each run?
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |
References |