Forum Stats

  • 3,824,876 Users
  • 2,260,435 Discussions
  • 7,896,336 Comments

Discussions

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

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?

Tagged: