Similar Posts
Conversations with Data Warehouse Experts – John Johansen at Majesco
In this episode, it is my pleasure to speak with John Johansen, Senior Vice President, Consulting Services Strategy & Innovation at Majesco, a leading provider of insurance solutions and services. He is a highly skilled consultant and data architect known for his ability to help insurers build effective data organizations. He is an entrepreneur who exited…
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.
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…
Dimodelo Data Warehouse Studio 2.15 – Whats New
Dimodelo Solutions is proud to announce the release of version 2.15 of Dimodelo Data Warehouse Studio, its data warehouse automation tool for the Microsoft data platform. In this release we have added support for the Microsoft APS platform and SQL Server 2017. We have also redesigned our data management architecture from the ground up, introducing…
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)….