Basics - explain the flow of data starting with OLTP to OLAP including staging ,summary tables,Facts and dime

GeekInterview.com > Interview Questions > Data Warehousing > Basics

Go To First | Previous Question | Next Question

Basics | Question 88 of 113

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

Total Answers and Comments: 6

Last Update: June 19, 2008 Asked by: madhuom

Sponsored Links

Best Rated Answer

—

Submitted by: jaggu_mandya

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

Above answer was rated as good by the following members:
phdsong, mri_sonam, Vamshidhar

February 07, 2007 04:10:08

Sruthi

RE: explain the flow of data starting with OLTP to OLA...

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

Is this answer useful? Yes | No

February 16, 2007 03:38:55

tushar_jog

RE: explain the flow of data starting with OLTP to OLA...

Hi Can I get more information about summary table?

Is this answer useful? Yes | No

February 16, 2007 07:26:24

madhuom

Member Since: February 2007 Contribution: 4

RE: explain the flow of data starting with OLTP to OLA...

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

Is this answer useful? Yes | No

January 17, 2008 08:48:24

jaggu_mandya

Member Since: January 2008 Contribution: 9

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

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

Is this answer useful? Yes | No

3 0

Overall Rating: +3

March 05, 2008 04:10:34

verma_tushar

Member Since: February 2008 Contribution: 1

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

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.

Is this answer useful? Yes | No

June 19, 2008 07:44:22

wnthanuja

Member Since: June 2008 Contribution: 1

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

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)

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank