Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Data Warehousing, ETL Rss

   Items 1 to 7 of 7   
 

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 | 3,862 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,066 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 | 712 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,456 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,235 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 | 3,742 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,013 reads
   Items 1 to 7 of 7   
 
Tags
data mart (1)    
integration services (ssis) (1)    
online (1)    
parallel (1)    
partition (1)    
partitioning (1)    
populate (1)    
try..catch (1)    
very large table (1)