Friday, September 17, 2010

My takeaways from Adam Jorgensen's 24HOP session -- Zero to cube

Here are my takeaways from today's fantastic session of Adam


  • The first basic point was you can use "." instead of "localhost" to choose the localhost server.
  • Defining the attribute relationship was very clearly explained that the relatiosnhps should be from the lowest level to the highest level.
  • Proactive caching -- available in from SQL SERver 2008 but the refresh property is available in Excel 2007 but sometimes may not work properly.

The following two resources which are quite useful was also discussed.


The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling

Microsoft SQL Server Product Samples: Database

No comments:

Two ways to reset the identity of a table in sql server.

I know of the following two ways to reset the identity of a table in sql server. You often tend to use dummy data during the course of y...