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?