Thursday, April 14, 2011

How to develop data warehouse architecture

Defining the architecture design of a data warehouse could be described into several steps:
* first step, select a process,
* second step, select up the grain fact table,
* third, select the dimension and,
* finally select the way to handle updates.
for the successful development of data warehouse should the focus be weight on business not on technology.
Derivative development technology should be used, and the most important is find the right developer of the project (include the user who shall responsible for the data warehouse)

No comments:

Post a Comment