Course details

Data Flow Implementation

Data Flow Implementation


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description
Extract, transform, load (ETL), is the main process in data warehousing solutions and helps transfer data from one source to another. During this course you will examine the ETL process and how it can be implemented. You will start by examining data flows and how to debug them. Next, you will learn how to use SQL Server Integration Services (SSIS), and perform a broad range of data migration tasks. These include how to create SSIS packages, transform data, and perform lookup tasks. Next you will employ ETL, the SSIS data warehousing tool, to facilitate the transfer of data from a source to a destination. Discover how to implement the ETL process, to extract, transform, and load data. Specify a data source and a destination. Finally, you will performance tune SSIS data flow and optimize data Integration Services.

Target Audience
Data warehouse developers and database administrators who create and manage business intelligence solutions as part of their daily tasks, which include implementing data warehouse databases, extracting and transforming data as part of an ETL solution, and data cleansing

Prerequisites
None

Expected Duration (hours)
1.1

Lesson Objectives

Data Flow Implementation

  • start the course
  • list data flow components
  • use data flows
  • debug data flow
  • Create SSIS packages and SQL/SSIS data transformations
  • perform lookup tasks in SSIS
  • specify a data source and destination
  • extract, transform, and load data
  • performance tune SSIS data flow and optimize Integration Services
  • Course Number:
    md_idwm_a05_it_enus

    Expertise Level
    Intermediate