|
|
|
 |
M2092Designing and Populating a Data Warehouse with Microsoft? SQL Server 2000 Data Transformation Services
This course will help students to acquire necessary knowledge and skills for development of repositories and their fillings by resources DTS Microsoft SQL Server 2000
the Program of course:
- Usage DTS in Repositories
- Definition of structures of Repositories
- Loading of structures of Repositories
- Usage of the wizard
- Presentation of units DTS
- Copying data
- Execution of a data conversion
- Complex data conversions
- Inquiries Data Driven
- Storage of packages and the metadata
- Fulfilment of packages
- Customization of properties of a package
- Construction of complex circuits of conversion
- Practical guidelines
- the Example of loading of the circuit of a star
Necessary preparation:
Acquaintance to Microsoft SLQ 7.0 or 2000. Knowledge of language Transact-SQL. Understanding of bases of programming (Microsoft Visual Basic or Microsoft JScript).
This course will help you to prepare for the next tests:
070-019 Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0
Given cource inserted in next comlex programs:
OLAP2000 The complex program of preparation of developers of OLAP-systems on the basis of DB Microsoft SQL Server 2000
Education coast on cource - USD 400
Cource duration (days) - 5
|
|
