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

Post Details

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