MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

Advanced Integration Services

Course Summary

This course explains how to apply Integration Services features to build packages that support the extract, transform and load operations of a data warehouse. It covers design patterns for staging data and for loading data into fact and dimension tables.

  • +

    Course Syllabus

    ● Data Warehousing Packages, Part I
        ◦ Introduction
        ◦ Introduction to Data Warehousing
        ◦ Dimensional Modeling
        ◦ Data Profiling
        ◦ Demo: Data Profiling
        ◦ ETL Design Patterns
        ◦ Extract Package
        ◦ Demo: Extracting to Staging Tables
        ◦ Load Patterns
        ◦ Fact Extract for Ongoing Load
        ◦ Demo:Extracting Records since Last Load
        ◦ Summary
        ◦ Data Warehousing Packages, Part II
        ◦ Introduction
        ◦ Slowly Changing Dimensions
        ◦ Dimension Load Patterns: Type 0, Type 1, and Type 2
        ◦ Dimension Load Package
        ◦ Demo: Transforming and Loading Data for Type 0
        ◦ Demo: Loading Data with The Slowly Changing Dimension Wizard
        ◦ Fact Table Design Patterns
        ◦ Demo: Performing ETL for A Fact Table
        ◦ Demo: Selecting Data for Ongoing Fact Table Load
        ◦ Analysis Services Objects
        ◦ Demo: Using The Analysis Services Task
        ◦ Demo: Orchestrating The ETL Process
        ◦ Summary
    ● Data Cleansing
        ◦ Introduction
        ◦ Data Flow and Data Quality
        ◦ Column Problems: Missing Data Default
        ◦ Demo: Derived Column
        ◦ Columnn Problems: Derive Missing Data
        ◦ Demo: Lookup Transformation
        ◦ Column Problems:Translation
        ◦ Demo: Lookup Transformation and Cache Transformation
        ◦ Column Problems: Data Type
        ◦ Demo: Data Conversion Transformation
        ◦ Column Problems: Truncation
        ◦ Demo: Flagging Unfixable Data Flow Errors
        ◦ Record Problems: Missing Dimension Data
        ◦ Demo: Inferred Members
        ◦ Record Problems: Lookup Failures
        ◦ Demo: Fuzzy Lookup Transformation
        ◦ Record Problems: Duplicate Data
        ◦ Record Problems: Fuzzy Grouping and Data
        ◦ Business Rule Problems: Out of Range Values
        ◦ Data Quality Services
        ◦ Summary
    ● Package Performance
        ◦ Introduction
        ◦ Pipeline Buffer Architecture
        ◦ Non-Blocking Streaming Transformations
        ◦ Demo: Executing Non-Blocking Streaming Transformations
        ◦ Non-Blocking Row-Based Transformations
        ◦ Demo: Executing Non-Blocking Row-Based Transformations
        ◦ Partially Blocking Transformations
        ◦ Demo: Executing Partially BlockingTransformations
        ◦ Blocking Transformations
        ◦ Demo: Executing Blocking Transformations
        ◦ Synchronous versus Asynchronous
        ◦ Execution Trees
        ◦ Demo: Reviewing The Pipeline Execution Tree Log
        ◦ Performance Optimization: Buffers
        ◦ Demo: Performance Optimization: Buffer Sizing
        ◦ Parallelism, Transformations, Sources, and Destinations
        ◦ Performance Monitoring
        ◦ Summary


Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Related Posts:

Extract, Transform, Load (ETL)


Design Patterns


SQL (Structured Query Language)


Data cleansing


Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top