Similar Posts
Tutorial 1 – Generate
LinkedIn Twitter
Conversations with Data Warehouse Experts – Hans Michiels
Join me for an informative discussion with Hans Michiels, founder and moderator of the Data Warehouse Automation Guide – DataWarehouseAutomation.Guide. Hans is an independent Business Intelligence and Data Warehouse consultant using Microsoft technology, working in the Netherlands. He has a special interest in Data Warehouse Automation and Metadata solutions. You can connect with Hans…
Conversations with Data Warehouse Experts – James Serra
In this episode, it is my pleasure to speak with James Serra, Data Platform Solution Architect and Data Warehouse Evangelist at Microsoft. He is a thought leader in data warehousing and data management with over 25 years of experience in data modeling, data governance, and development methodologies. James is also a popular and prolific blogger…
Conversations with Data Warehouse Experts – Dr. Claudia Imhoff
In this episode, it is my pleasure to speak with Dr. Claudia Imhoff, a real rock star in our corner of the technology universe. She not only has the technical chops and but also an in-depth understanding of the business landscape. In 1992 she founded her consulting company, Intelligent Solutions, Inc., and in 2006 she…
The Dimodelo Data Warehouse Studio code generation process
This post discusses in detail how Dimodelo Data Warehouse Studio generates code to create and manage a Data Warehouse, including creating and managing Data Warehouse Databases, Tables and ETL procedures. While Dimodelo Data Warehouse Studio has a set of predefined Generation Templates and Generation Providers , it is also extensible, allowing end users to create their own Generation Templates and Generation Providers.
Defining a Dimension with Smart Keys
While conventional wisdom (and Kimball) says that using meaningful identifiers for surrogate keys is a bad idea, there are some exceptions where it makes sense. Typical examples include: Calendar. An example of a Calendar smart key is – year, month, day e.g. 20110721. A DateTime value can be converted to this date format using this statement convert(char(8),date, 112)….