Sruthi

• Feb 7th, 2007

 

The flow of data from OLTP to OLAP is as follows:
1. Staging tables
2. Dimension tables
3. Fact tables or (Fact and Summary Tables)
4. Summary Tables

tushar_jog

• Feb 16th, 2007

 

Hi,Can I get more information about summary table?

madhuom

 Profile Answers by madhuom Questions by madhuom

• Feb 16th, 2007

 

Summary tables are tables which contain summarised information for e.g sales summary of a product in a region

jaggu_mandya

 Profile Answers by jaggu_mandya 

• Jan 17th, 2008

 

OLTP(1)---->ODS(2)------>DWH(3)-------->OLAP(4)------------>Reports(5)------>decision(6)

1-2 (extraction)
2-3 (Transformation and here ODS is itself staging area )
3-4-5 (Use of reporting tool and generate reports)
6-decision is taken i,e purpose of datawarehouse is served

I think this is right picture

verma_tushar

 Profile Answers by verma_tushar 

• Mar 5th, 2008

 

In some of the cases Pre Stage is also a intermediate phase between the OLTP environment and actual staging area.
The prestage is one where dta clensing, data profiling nad data validation takes place. In stage, on the other hand. we apply actual business logic of the ETL phase to bring baout the requiered OLAP objects.
However, both prestage and stage form ODS(Operational Data Source) together.

wnthanuja

 Profile Answers by wnthanuja 

• Jun 19th, 2008

 

Source System data ----------Extraction---------Transformation(Clenance the data according to business logics)(As dimensions)----------Takes data from the dimension tables in to fact tables using Surrogate keys---------------Load (As cubes)(In to the staging)