Database DataWarehousing (MOSC)

MOSC Banner

Approach for schema changes minimize downtime

edited Dec 31, 2013 6:06AM in Database DataWarehousing (MOSC) 3 commentsAnswered
We have built a data mart consisting of 50+ fact and dimension tables running Oracle Exadata 11.2.  Microstrategy analytics use these structures.  We routinely need to make modifications to these structures, including adding columns, removing columns, changing ETL logic which will result in a complete reload of a fact table.  When we put a new release into production, it requires downtime for the Microstrategy business users.  We are looking for approaches to minimize this downtime.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center