Author Topic: Content of MSBI 2012 Part 1 SSIS ETL  (Read 8284 times)

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 3880
  • Karma: +35/-11
Content of MSBI 2012 Part 1 SSIS ETL
« on: March 17, 2014, 12:31:46 AM »
视频:
https://www.youtube.com/watch?feature=player_embedded&v=1adN3fLqFHc
USA LaoTu MSBI 2012 Part 1 SSIS ETL 课 坐家妈妈这样通过做项目 一步一步走出家 :
http://www.youtube.com/watch?v=VXTRNj9CLeU

MSBI2012 Part 1 SSIS ETL
CLASS 1st 4 hour
    ETL Working Environment
    SSIS lab 1-4 Demo
    Data Modeling Project 1/5

CLASS 2nd  4 hour:

     SSIS lab 4-6 Demo
     Flat file Load—varying column width
     Data Modeling Project 2/5

CLASS 3rd 4 hour:

     Data warehouse: Dimension table ETL
     Truncate and delete in ETL
     How to apply Surrogate Key in Data Warehouse
     Data warehouse: Unique Constrain, migration from DEV to PRO
     Data Modeling Project 3/5

CLASS 4th 4 hour:

      Data warehouse: Fact table ETL
      Data warehouse: Audit table creation and ETL
      Incremental Loading
      Data Modeling Project 4/5

CLASS 5th 4 hour:

      Master Package Design---XML method
      How to parse XML data
      Data warehouse: Unique Constrain, migration from DEV to PRO
      How to deploy SSIS package to Production---Environment Variable Method
    Maintaining Production Server—process of fixing production issues
    Data Modeling Project 5/5

CLASS 6th 4 hour:

    More real work projects.