SQL Server Integration services program details

SQL Server Integration services

Description

SQL Server Integration services is a platform for building enterprise-level data integration and data transformations solutions to solve complex business problems by loading data into Data Warehouse.

What will you learn
  • Introduction
  • SSIS Architecture
  • SSIS - Framework
  • Control Flow
  • Data Flow
  • Incremental and Full Loading
  • SSIS Design Patterns
  • Handling Advanced Data Warehouse Scenarios
  • Handling Files
  • Event Handlers
  • Extraction
  • Data Cleansing
  • Fact ETL
  • Dimension ETL
  • SSAS Cube Processing with SSIS
  • Scaling SSIS
  • Deployment Work Flows
  • Real Time Scenarios

Sections