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