Explain the flow of data starting with OLTP to OLAP including staging ,summary tables,Facts and dimensions.

Questions by madhuom   answers by madhuom

Editorial / Best Answer

jaggu_mandya  

  • Member Since Jan-2008 | 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

Showing Answers 1 - 0 of 0 Answers

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

  Was this answer useful?  Yes

tushar_jog

  • Feb 16th, 2007
 

Hi,Can I get more information about summary table?

  Was this answer useful?  Yes


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

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.

  Was this answer useful?  Yes

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)

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions