Tutorial 1 – Generate
Similar Posts
Tutorial 1 – Wizard
LinkedIn Twitter
Conversations with Data Warehouse Experts – Dr. Barry Devlin
Join me for an enlightening conversation with Dr. Barry Devlin, regarded as one of the world’s leading authorities on business insight and data warehousing. He was responsible for the definition of IBM’s data warehouse architecture in the mid-1980s which in our view makes him the “Godfather” of the data warehouse . He is now founder…
Tutorial 1 – Getting Started
In this tutorial you will learn how to use Dimodelo Data Warehouse Studio to:
Create a new Data Warehouse project.
Create a connection to a Source System.
Use the Wizard to generate the Meta Data for a Data Warehouse and its Extract, Transform and Load processes (ETL).
Generate the code to create the Data Warehouse and Staging databases, and the ETL to move data from the source through to the Data Warehouse.
Deploy the code to the Server.
Execute the ETL batch.
Tutorial 1 – Run ETL Batch
LinkedIn Twitter
Creating and Using a Derived Staging Table
What is a derived staging table? It’s a table created in your Staging database that derives its data from other already existing Staging tables. Its useful for creating aggregations, or allocations of data prior to the transform and load process into your Data Warehouse. It can also be useful for tables that don’t have any…
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…