Archive

Archive for the ‘Data Warehouse’ Category

The final edition DWH and BI reference

January 10, 2016 2 comments

Ralph Kimball and the Kimball Group have continued to refine their methods and techniques based on thousands of hours of consulting and training. This Remastered Collection of The Kimball Group Reader represents their final body of knowledge, and is nothing less than a vital reference for anyone involved in the field.

  1.  Learn data warehousing and business intelligence from the field’s pioneers
  2. Get up to date on best practices and essential design tips
  3. Gain valuable knowledge on every stage of the project lifecycle
  4. Dig into the Kimball Group methodology with hands-on guidance

Download this book

Thanks

Advertisements
Categories: Book, Data Warehouse

Lookup Table


Just a concept. It has been already discussed by data management experts. But, I just renew the thoughts.

What is OTLT (One True Lookup Table) or common lookup table or single source lookup table?
It is a place or a table to keep all the lookup data and maintain the single source for the data management. For instance, data loading for DWH.

Benefits:
-Easy manageability, which is the most necessary component of the life cycle of the data warehouse.
-Single source of data truth

I am stopping here for you to comment about the topic and further discussion.

Categories: Data Warehouse, SSIS Tags: ,

Next step in Data Warehouse

January 15, 2010 2 comments

Parallel Data Warehouse – It is a next level of Data Warehouse scenario to an organization. This helps organization to have low cost multi terabyte Data Warehouse to server millions of customer.

PDW is introduced with SQL Server 2008 R2.

for more information you can watch short videos in the microsoft website.

http://www.microsoft.com/sqlserver/2008/en/us/parallel-data-warehouse.aspx

Diclaimer: This post is to give technical reference for educational purpose and not for commercial activities.

%d bloggers like this: