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