Designing Data Flow


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



Overview/Description
When working with data in a data warehouse, some level of transformation is usually required between the source and destination. In this course, you will learn about transformation and designing data flow.

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

Designing Data Flow

  • start the course
  • determine the need for supporting Slowly Changing Dimensions transformations
  • determine whether to use SQL Joins or SSIS lookup or merge join transformations
  • describe batch processing and row-by-row processing
  • describe identity mapping methods
  • recognize methods for deduplication
  • describe fuzzy lookup
  • Implement a fuzzy lookup in SSIS
  • determine what to do with erroneous and changed rows
  • determine auditing needs for SSIS packages
  • use data flow to load data in SQL Server 2014
  • Course Number:
    md_idwm_a04_it_enus

    Expertise Level
    Intermediate