Frank, why would that be considered best practice? A temporal relational data warehouse in database tables captures more data than a dimensional model, has a lower footprint on disk, and has better performance when searching for a small number of records within large datasets. The OLAP structure, modeled dimensionally, provides the best performance when aggregating large datasets. I don't understand why creating an intermmediate data store dimensionally in database tables would be considered best practice.
Jay Quincy Allen, Managing Partner, ADAMA Systems