<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Content with tag
Data Warehouse
Items 1 to 7 of 7
Low Profile Architecture
The goal of this article to show how to get unique transactions per client per month from the data set containing multiple transactions per client per month.
Read more...
By
Igor Zaychik
2013/04/02
|
Source:
SQLServerCentral.com
|
Category:
sql
Rating:
|
Discuss
|
Briefcase
|
2,863 reads
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:
SQLServerCentral.com
|
Category:
date dimension
Rating:
|
Discuss
|
Briefcase
|
990 reads
ETL Performance Auditing - Part 1: Introduction to ETL Auditing
This article shows an easy way to setup a comprehensive ETL Performance auditing Solution no matter how complicated your ETL setup.
Read more...
By
Frank A. Banin
2012/06/05
|
Source:
SQLServerCentral.com
|
Category:
etl performance
Rating:
|
Discuss
|
Briefcase
|
8,736 reads
RegEx for DBAs
RegEx functions are incredibly powerful text handling functions which should be at the top of a data warehouse DBAs list when writing CLR functions
Read more...
By
David Poole
2012/05/08
|
Source:
SQLServerCentral.com
|
Category:
regex
Rating:
|
Discuss
|
Briefcase
|
9,876 reads
Using The Kimball Dimensional Modeling Tool
Using the Kimball Data Warehouse Modeling Tool in an agile setting supporting regular builds and integrated testing with work a rounds to cover non-SQL Server systems.
Read more...
By
Jim Nichols
2011/10/31
|
Source:
SQLServerCentral.com
|
Category:
bi
Rating:
|
Discuss
|
Briefcase
|
6,215 reads
Data Warehouse Development: Version 0
What do you do first when developing a data warehouse? MVP Andy Leonard brings us a look at the foundation he uses, which might surprise you.
Read more...
By
Andy Leonard
2011/04/07
|
Source:
SQLServerCentral.com
|
Category:
data warehouse
Rating:
|
Discuss
|
Briefcase
|
8,712 reads
Creating Inferred Dimension Members with SSIS
This article will show you how to use SSIS to create inferred dimension members on the fly during a fact table load process.
Read more...
By
Robert Rubocki
2010/12/08
|
Source:
SQLServerCentral.com
|
Category:
data warehouse
Rating:
|
Discuss
|
Briefcase
|
6,717 reads
Items 1 to 7 of 7
Tags
bi
(2)
integration services (ssis)
(2)
data mart
(1)
database
(1)
datamart
(1)
date dimension
(1)
dimensional modeling
(1)
etl
(1)
etl performance
(1)
excel
(1)
fact table
(1)
kimball
(1)
regex
(1)
regular expressions
(1)
reporting services (ssrs)
(1)
scd
(1)
script component
(1)
sql
(1)
sqlclr
(1)
star schema
(1)
t-sql
(1)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
