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 111

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

—

No best answer available. Please pick the good answer available or submit your answer.

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

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