Tutorial 1 – Generate
Similar Posts
Data Driven Design with Agile for Data Warehousing
An introduction to using Data Driven Design and the Agile Project Methodology to quickly deliver a Data Warehouse.
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 – Deploy
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…
Tutorial 1 – Run ETL Batch
LinkedIn Twitter
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…