Course Details

Previous Page


Data Flow Implementation


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


Overview/Description
ETL, extract, transform, and load, is the main process in data warehousing solutions. It facilitates the transfer of the data from a source to a destination. This course discusses the ETL process and how it can be implemented.

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