Data Warehousing Community Forum
February 09, 2012, 01:33:46 pm

Pages: [1]   Go Down
« previous next »
  Print  
Author Topic: Database Structure @ each stage  (Read 521 times)
aarunkumarj
DW Fresher
*

Reputation: +0/-0
Offline Offline

Posts: 1


View Profile
« on: July 07, 2010, 01:19:35 pm »
I'm a beginner in DWH. I have a question in the database structure.

The source/transaction system will be having a normalized table structure ie., the ER model.

The DWH and the data marts will be having the fact and dimension structure with foreign key relations ie the dimensional model.

Please correct me if I'm wrong.

What is the DB structure in the staging area? Does the staging area has the same structure of the DWH or the data mart?

Could you please share some DB structures from Transactional System to Data mart?

Thanks in Advance
Logged
Whoever
Administrator
*****

Reputation: +34/-0
Offline Offline

Posts: 124



View Profile WWW
« Reply #1 on: July 15, 2010, 11:55:12 am »
Quote from: aarunkumarj on July 07, 2010, 01:19:35 pm
What is the DB structure in the staging area? Does the staging area has the same structure of the DWH or the data mart?
The DB structure for the staging area could be whatever you design it to be.

In most cases, the DB structure of the staging area is a mix of normalized tables similar to those in your source (the source data would be copied here with little or no modifications) and denormalized tables similar to those in the DWH (for intermediate storage of data that is being processed).
Logged
If most people said what’s on their minds, they’d be speechless.
Pages: [1]   Go Up
  Print  
« previous next »
 
Jump to: