Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Data Warehousing, ETL Rss

   Items 1 to 8 of 8   
 

A Tale of Partition Schemes and Disappearing Dragons

A tale in which is detailed how I used SWITCH PARTITION to efficiently load my data and save myself from the flaming jaws of death.  Read more...
By Porter James 2015/11/02 | Source: SQLServerCentral.com | Category: partitioning
Rating: |  Discuss |   Briefcase | 3,389 reads

Implementation of partition switching within SSIS

In the third part of a series on loading a partitioned data warehouse efficiently, we see how SSIS can be used to perform the ETL tasks.  Read more...
Rating: |  Discuss |   Briefcase | 4,620 reads

Data Warehousing Architecture - Designing the Data Staging Area

The staging area tends to be one of the more overlooked components of a data warehouse architecture, and yet it is an integral part of the ETL component design. Learn why it is best to design the staging layer right the first time, enabling support of various ETL processes and related methodology, recoverability and scalability.   Read more...
By Additional Articles 2010/07/07 | Source: Database Journal | Category: data warehousing
Rating:  Rate this |   Briefcase | 5,426 reads

Populate partition

Fill a specified partition of a table with a specific query, working on staging table   Read more...
By Federico Iori 2010/03/25 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 733 reads

Kimball University: Three ETL Compromises to Avoid

Why neglecting slowly changing dimensions, failing to capture metadata and overlooking scope creep can be the undoing of a dimensional data warehousing initiative.  Read more...
By Additional Articles 2010/03/11 | Source: Intelligent Enterprise | Category: data warehousing
Rating: (not yet rated)  Rate this |   Briefcase | 3,814 reads

Conditional Set-Based Processing: Moving Towards a Best Practice for ETL

When you need to insert a large set of data using T-SQL, what can you do? New author Melinda Sansone brings us a best practice when using T-SQL to load data for data marts, or warehouses.  Read more...
By Mel Sansone 2009/11/23 | Source: SQLServerCentral.com | Category: data mart
Rating: |  Discuss |   Briefcase | 8,268 reads

Kimball University: Six Key Decisions for ETL Architectures

Best-practice advice on software vs. coding, where to integrate, how to capture changed data, when to stage data, where to correct data and what latency levels to shoot for.  Read more...
By Additional Articles 2009/10/20 | Source: Intelligent Enterprise | Category: data warehousing
Rating:  Rate this |   Briefcase | 4,028 reads

How to Calculate Data Warehouse Reliability

This article outlines a more objective and analytical approach to the ETL and data flow architecture selection based on a set of variables with an objective to enhance the reliability of the overall data warehousing solution.  Read more...
By Additional Articles 2009/09/29 | Source: DMReview | Category: data warehousing
Rating: (not yet rated)  Rate this |   Briefcase | 4,296 reads
   Items 1 to 8 of 8   
 
Tags
partitioning (2)    
columnstore index (1)    
data mart (1)    
integration services (ssis) (1)    
online (1)    
parallel (1)    
partition (1)    
populate (1)    
try..catch (1)    
very large table (1)