SQL Warehousing tutorial
In this tutorial, you will learn the basics of SQL warehousing, including how to create a physical data model, data flows that transform your data, control flows that run your data flows, and how to deploy a data warehouse application.
For this tutorial, you will work with data from the fictional Sample Outdoors company, which sells and distributes products to third-party retailer stores around the world. The fictional Great Outdoors company has a wealth of data in its database, the GSDB database.
For the last several years, the company has steadily grown into a worldwide operation. The sales database that the company uses, GSDB, has become large and difficult to query. The company now finds it difficult to determine how each of the locations are performing over time.
The fictional Sample Outdoors data warehousing team is committed to consolidating the company data into a new data mart that provides a consistent data source for analysis and reporting. The warehousing team has decided to use, which is an enterprise product that can help the company by providing the tooling to access and transform sales data into a more manageable data mart.
For this tutorial, you will use the data in the GSDB database and build a data mart to track sales over time for the various store locations in the fictional Sample Outdoors company.
Learning objectives
After completing this tutorial, you will understand the concepts and know how to do the following tasks:- Design a physical data model for your data warehouse
- Create simple data flows
- Create control flows and prepare for deployment
- Deploy and run the control flow application in the Administration Console
Time required
This tutorial should take approximately 3 hours to complete.- Module 1: Designing the physical data model for your data warehouse
In this module, you will connect to the GSDB database and create a physical data model for the new data mart that you will build. You will create a MARTS schema in the data model and then update the GSDB database with the changes. - Module 2: Designing data flows
In this module, you will design three data flows to populate the tables in your data warehousing project. Data flows define the SQL-based data movement and transformation activities that run in a Db2® database. - Module 3: Creating control flows and preparing for deployment
In this module, you will learn how to create control flows and application packages in Design Studio. - Module 4: Deploying an application and running the control flows in the Administration Console
In this module, you will learn to use the Administration Console to deploy and manage the data warehousing application that you created in the Design Studio.