MEAPSA

Load data into a relational data warehouse

A core responsibility for a data engineer is to implement a data ingestion solution that loads new data into a relational data warehouse.

Data Engineer

Synapse Analytics

Module Objectives

In this module, you'll learn how to:

Load staging tables in a data warehouse
Load dimension tables in a data warehouse
Load time dimensions in a data warehouse
Load slowly changing dimensions in a data warehouse
Load fact tables in a data warehouse
Perform post-load optimizations in a data warehouse

Units

Introduction min
Load staging tables min
Load dimension tables min
Load time dimension tables min
Load slowly changing dimensions min
Load fact tables min
Perform post load optimization min
Exercise - load data into a relational data warehouse min
Knowledge check min
Summary min

Prerequisites

Before starting this module, you should be familiar with data warehouses in Azure Synapse Analytics. Consider completing the Analyze data in a relational data warehouse module first.