SQL Server Partitioned View vs Partition Table
SQL Server Partitioned View vs Partition Table Small Demo Code for Creating Partition Table Anot
Home »
Data Warehouse
Surrogate keys and lookup Transformation in Developing Data Warehouse
Surrogate keys and lookup Transformation in Developing Data Warehouse: With conformed Dimensions approach, the Sk’s are created in when Dimensions are created by using Identity prope
How is the Audit table helpful in DataWarehouse Development Cycle
How is the Audit table helpful in DataWarehouse Development Cycle? The answer looks obvious which is debugging the package but what kind of information is normally loaded into a Audit Table and how i
Tips for Developing a Data Warehouse 1
1. Think of the Business requirements first. 2. Get the list of source destinations 3. Setup a Staging Database to separate out the “Extract” out of ETL. 4. Always use master and child packages for ma