Basics - how data in datawarehouse stored after data has been extracted and transformed from hetrogeneous so

GeekInterview.com > Interview Questions > Data Warehousing > Basics

Go To First | Previous Question | Next Question

Basics | Question 79 of 111

how data in datawarehouse stored after data has been extracted and transformed from hetrogeneous sources and where does the data go from datawarehouse.

Total Answers and Comments: 6

Last Update: March 01, 2007 Asked by: elektra

Sponsored Links

Best Rated Answer

—

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

October 19, 2006 15:47:06

Nagadevi Kavali

RE: how data in datawarehouse stored after data has be...

Data in Data warehouse (Bill Inmon's approach) is stored in Relational form.

Is this answer useful? Yes | No

October 19, 2006 23:48:07

elektra

RE: how data in datawarehouse stored after data has be...

ok i got u

but what i want to know is,is data in datawarehouse is stored in dimesional schema or what

thanks in advance.

Is this answer useful? Yes | No

November 09, 2006 22:40:48

Brave

RE: how data in datawarehouse stored after data has be...

Data in Datawarehouse stored in the form of relational tables, most of the dataware houses approch is snowflake schema

Is this answer useful? Yes | No

November 27, 2006 10:18:53

madhu

RE: how data in datawarehouse stored after data has be...

OK I agree what you have described but I have got a little doubt you said that it is between relational tables but as i think there the tables are kept denormalised form. then how come it is relational to eachother.

Is this answer useful? Yes | No

December 05, 2006 14:49:43

Ram

RE: how data in datawarehouse stored after data has be...

Data is stored in structured array format/style...

Ofcourse it is relational but format differs

Is this answer useful? Yes | No

March 01, 2007 03:01:48

tacklu

RE: how data in datawarehouse stored after data has be...

In datawarehouse data is stored in dimension, fact and summary tables and ofcourse they have relationship with each other

Is this answer useful? Yes | No

Go To Top