SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags Data Warehousing, Extract, Transform, Load (ETL) Rss

   Items 1 to 4 of 4   

CDC and Data Warehouse

The following article shows how Change Data Capture can be used to capture incremental data changes and use them in an ETL Process  Read more...
By Additional Articles 2008/11/10 | Source: SQL Server Performance | Category: data warehousing
Rating:  Rate this |   Briefcase | 3,729 reads

Kimball ETL Part 1 – Data Profiling via SSIS Data Flow

A new series sponsored by Actuality Business Intelligence on data warehousing. In part 1, the data flow in SSIS packages are used to profile the source data and determine how it should be handled in the process.  Read more...
Rating: |  Discuss |   Briefcase | 8,883 reads

Parallel Processing of Large Volume ETL Jobs

ETL processing, generally involves copying/moving, transforming, cleaning the records/transactions from one or multiple sources. Most of the batch processing or warehousing projects involve such data processing in millions on daily/weekly basis. Typically, there is a Staging area and production area. Records are cleaned, transformed, filtered and verified from staging to production area. This demands SQL Set theory based queries, parallel processing with multiple processors/CPU. The article focuses on need of SQL Set theory approach and parallel processing while processing large volume of ETL records using programming approach.   Read more...
Rating: |  Discuss |   Briefcase | 5,019 reads

The Subsystems of ETL Revisited

These 34 subsystems cover the crucial extract, transform and load architecture components required in almost every dimensional data warehouse environment. Understanding the breadth of requirements is the first step to putting an effective architecture in place.  Read more...
Rating:  Rate this |   Briefcase | 3,091 reads
   Items 1 to 4 of 4