Load data into a relational data warehouse

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

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.