Fact Table Training on CD-ROM
Fact Table Training Provider? - Tell us about your Training!
From 123-CBT Computer Based Training
SQL Server 7 0 Data Warehousing Set of 4
....12 Defining other Types of Dimensions 2.13 Defining the Fact Table 2.14 Defining Pre-calculations 2.15 Minimizing the Fact Table Size & Balancing Size & Performance 2.16 Estimating Size of the Data Warehouse 2.17 Creating a Database 2.18 Creating Constraints 2.19 Creating Indexes & The Index Tuning Wizard SQL 7.0 Data Warehousing Level 2 (1 Hr 48 Mins) 1.0 Building the
more...
SQL Server 7 0 Data Warehousing Set of 4
SQL Server 7 0 Data Warehousing Level 1
SQL 7.0 Data Warehousing Level 1 (1 Hr 41 Mins) 1.0 Prerequisites (28 Mins) 1.1 Course Prerequisites 1.2 System Setup 1.3 Defining Data Warehousing 1.4 Operational & Analytical Systems 1.5 Comparing Transactional and Data Warehousing Solutions 1.6 Data Marts 1.7 Know the Flow 1.8 Microsoft Data Warehouse Tools 1.9 Data Warehouse Characteristics 2.0 Designing a Data Warehouse (1 Hr
more...
SQL Server 7 0 Data Warehousing Level 2
....3 Build Dimension Tables 1.4 Using Scripts & Building a Fact Table 2.0 Validating and Transforming Data (53 Mins) 2.1 Process Overview 2.2 Methods of Populating a Data Warehouse 2.3 Tools for Populating a Data Warehouse 2.4 Transact-SQL 2.5 Distributed Query 2.6 bcp Utility and the BULK INSERT Statement 2.7 Data Transformation Services (DTS) 2.8 Transferring a File Using DTS 2.9
more...
SQL Server 2000 Data Warehousing Set of 5
... a Data Mart 1.1 Creating the Database 1.2 Creating the Fact Table 1.3 Creating Dimension Tables 1.4 Creating Constraints and Indexes 2.0 Loading the Data Mart 2.1 Using Staging Tables 2.2 Using Transact SQL for Data Migration 2.3 Loading Data using Data Transformation Services 2.4 Advanced DTS Issues 2.5 Evaluating a Typical Load Scenario 3.0 Maintaining the Data Mart 3.1 Backup
more...
