Designing Data Flow

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