[repost from Stephen Forte's Blog] See also: Part I: When to build your data warehouse Part II: Building a new schema Part III: Location of your data warehouse Part IV: Extraction, Transformation, and Load In
Part I we looked at the advantages of building a data warehouse
independent of cubes/a BI system and in Part II we looked at how to
architect a data warehouse’s table schema. In Part III, we looked at
where to put the data warehouse tables. In Part IV, we are going to look
at how to populate those tables and keep them in sync with your OLTP
system. Today, our last part in this...