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

Content with tag Data Mart Rss

   Items 1 to 3 of 3   

Create and Populate a Date Dimension Table

Creates and populates a date-dimension table suitable for OLTP or data warehouse purposes  Read more...
By Joseph Morgan 2013/02/04 | Source: | Category: date dimension
Rating: |  Discuss |   Briefcase | 1,385 reads

Merge, Metadata and the Data Mart ETL

Here's a great method for managing ETL for data marts and small data warehouses with just T-SQL.  Read more...
By Christopher Ross 2012/12/27 | Source: | Category: etl
Rating: |  Discuss |   Briefcase | 4,554 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: | Category: data mart
Rating: |  Discuss |   Briefcase | 8,265 reads
   Items 1 to 3 of 3   
etl (2)    
business intelligence (1)    
data warehouse (1)    
data warehousing (1)    
date dimension (1)    
merge (1)    
metadata (1)    
try..catch (1)    
t-sql (1)