Adding new fields to a live system

ponzie at 19h10
08
Apr
2009
Adding new fields to a live system

So, the DW DB is loaded with data of various SCD types.
The data is in live use.
New requirements arise that require new SCD 2 fields to be added.
Backups exist of the source systems.

Are there any design tips, experiences that anyone can share on how to populate the new SCD 2 fields.

Is it just a question of rebuilding the whole DW DB using those backups until you've caught up with 'Now'?
About
This topic belongs to the forum
  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
I'd like to add an option in the 'users & groups' > 'Profile' section within the admin panel to allow additional profile fields to be added to the memberlist page. Currently, the option to display profile fields is limited to display them
Hello, guys! I just made a forum and I would like to say that you did an amazing job. Now, I want to create a mood system for my forum, but I don't know how it's done. I see a button for activating reputation and points system, but I don't see one for
Just clocked this on Youtube! Seems they are planning to release a special edition album of the Elboys' performances at Pinkpop and Lowlands of this year. Due out this September! Anyway, that's what I figure... It's a terrible, cringey interview but
February 11, 2011 15:52 PM IMF Says Adding Chinese Yuan To SDR Still Too Early HONG KONG, Feb 11 (Bernama) -- The International Monetary Fund (IMF) said Friday it is still too early to add the Chinese yuan to international foreign exchange reserve
The Killing Fields In Cambodian
Forums from same category
See also
more_less
Informations

12 Replies For the topic :
"Adding new fields to a live system"

This topic has been viewed 7296 times.

Last message :
08/04/2009 at 19h10 by "ponzie"