Solved

what does staging area of data warehouse have there and what purpose of it?

Posted on 2011-03-06
3
925 Views
Last Modified: 2012-05-11
1. if we use staging area between ODS and EDW when perform ETL , what should be in staging area:

   i)  a copy of source tables  ,so the transformation is performing between staging area and EDW
   ii) a copy of target tables  , so the transformation is performing between ODS and staging area
   iii) a copy of source tables and a copy of target tables ,the transformation is performing at stage area

2.can the staging area be in the same source (ODS) database or in the EDW datawarehouse or it is in different database?
0
Comment
Question by:SayYou_SayMe
3 Comments
 
LVL 14

Accepted Solution

by:
ajexpert earned 250 total points
ID: 35046422
Well, it depends on requirement, but generally staging area table structure that is combination of source tables.

Once you have data collected in staging area from source tables, you then write a logic to load the data in target tables.

HTH
0
 

Author Comment

by:SayYou_SayMe
ID: 35046471
thanks ajexpert

the staging area has source tables , ETL quickly load the source data into staging area, and then load the data into target. so the transformation are performing between staging area and EDW

i) Is it possible that the staging area has target tables (dimension and fact table), transformation is performing at staging area, and then simple pass throught the staging target into EDW target?

ii) If perform incremental load, only load  the change source data,so the staging area :
   1. trucate load, there is only change source data there
   2. collect all the source data, so the staging area has the same amount data as source (ODS)
   which approach is better? and what is the pos/cons?

 
 
0
 
LVL 4

Assisted Solution

by:pinkuray
pinkuray earned 250 total points
ID: 35077972
i) Is it possible that the staging area has target tables (dimension and fact table), transformation is performing at staging area, and then simple pass throught the staging target into EDW target?

Yes it can ...

The staging db can have target tables but only if required a validation which can be done without disturbing the target table, for being to be in a safe said we can have this functionality.

So after all the validation in staging DB the loading can be done in target table in target DB.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
AWS RDS Backups? 3 52
sum of columns in a row in oracle 3 33
minium over 4 numeric columns for each row in oracle 2 29
Help with Oracle IF statment 5 26
This article explains all about SQL Server Piecemeal Restore with examples in step by step manner.
Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question