Re: Staging areas

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Marco Russo <marco.russo@xxxxxxxxx>
Date: Fri, 2 Jan 2009 01:48:29 -0800 (PST)

On Dec 31 2008, 6:22 pm, "Joe H" <hortoristic at gmail> wrote:

Our currenet archetecture is we have a
- PreStaging area (this is copies of the tables we are going to use - our
ODS)
- Staging (this is the results of the ETL - star schema) we have our
dimensions and facts
- Data Warehouse - we do a delta between Staging and Data Warehouse. Any
problems with the ETL only effected Staging

I know we could just go from PreStaging and ETL straight to the Data
Warehouse but it has been working for us better when we run into problems..
We don't have to roll out things from the DW if something fails is the big
thing.

How are others doing it?

I suggest you to take a look at the SQLBI Methodology (http://
www.sqlbi.com/sqlbimethodology.aspx) - we also have a forum to make
discussions about it - it's a very large and wide topic...

Marco Russo
http://www.sqlbi.com
http://sqlblog.com/blogs/marco_russo
.

Follow-Ups:
- Re: Staging areas
  - From: Joe H

Next by Date: Re: Staging areas
Next by thread: Re: Staging areas
Index(es):
- Date
- Thread

Relevant Pages

Re: Staging areas
... What I appreciate about Marco is not only ... Staging (this is the results of the ETL - star schema) we have our ... Data Warehouse - we do a delta between Staging and Data Warehouse. ...
(microsoft.public.sqlserver.datawarehouse)
Staging areas
... Data Warehouse - we do a delta between Staging and Data Warehouse. ... I know we could just go from PreStaging and ETL straight to the Data ...
(microsoft.public.sqlserver.datawarehouse)