Skip to Main Content
Forums

LiveLabs & Workshops

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to load data for newly added column in a dimension table?

ErrendousMay 31 2022

I'm currently working on ODI 12C and attending interviews. I get the below question asked very often. can someone help me answer this?
How do you load history data for newly added column in a dimension table ?
One way is to simply write an update statement but is there a way to do this via ODI without having to truncate the target table? what's the ideal way to do this?

Comments

Forms 11.x was desupported years ago. The signed jar files that came with that old version are now obsolete, as you should be able to deduce from the Java error message you are seeing.
Upgrade to the latest supported version, currently 12.2.1.4. I also strongly recommend that after upgrading you explore using the Forms Standalone Launcher rather than IE (or Edge) as using any variation of IE to run embedded applets is also no longer supported.
Details about the latest Forms version can be found on the Forms product page.
https://www.oracle.com/application-development/technologies/forms/forms.html

1 person found this helpful
User_9URBT

Means a lot, Sir, for your kind suggestion and guidance.

1 - 2

Post Details

Added on May 31 2022
#data-warehouse-reference-architectures-patterns, #odi
1 comment
269 views