|
Provided by: Wise Ltd. Advanced SQL Server 2005 Integration Services SSIS for DevelopersMS SQL Server |
 |
Training
Provided by Wise Ltd.
As SSIS is mainly an Extract, Transform and Load (ETL) tool and since ETL has been accepted as being between 70-80% of the data warehouse maintenance challenge, this course is accordingly dedicated. After discussing advanced features of the SSIS control and data flow engines, delegates will be taught how to design, develop and implement an SSIS-based ETL system, accounting for some of the more common and complex requirements, including:
- Source-to-destination mapping
- Extraction (e. g., incremental)
- Staging tables
- Slowly Changing Dimensions
- Late arriving (inferred) dimensions
- Late arriving facts
- Fact aggregation
- Data profiling
- Audit
- Etc.
Related Software Programs or Products: SQL Server 2005
Related Jobs or Careers: SQL Server 2005 developers in particular and DBAs in general.
|
|
||||||||||
Advanced SQL Server 2005 Integration Services SSIS for Developers
As SSIS is mainly an Extract, Transform and Load (ETL) tool and since ETL has been accepted as being between 70-80 of the data warehouse maintenance challenge, this course is accordingly dedicated. After discussing advanced features of the SSIS control and data flow engines, delegates will be taught how to design, develop and implement an SSIS-based ETL system, accounting for some of the more common and complex requirements, including:
- Source-to-destination mapping
- Extraction (e. g., incremental)
- Staging tables
- Slowly Changing Dimensions
- Late arriving (inferred) dimensions
- Late arriving facts
- Fact aggregation
- Data profiling
- Audit
- Etc.
About The Training Provider: Wise Ltd.
Wise Ltd. - Established in 1996, Wise Ltd. provides IT training and consulting services throughout the UK, Europe and the USA.
We specialise in business intelligence, data warehousing and OLTP courses on the following platforms: Oracle, SQL Server, DB2 for Linux/ UNIX/ Windows and DB2 mainframe. Additionally, we offer CICS, web development and MS Office training. Our instructor-led courses are offered...
