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 116

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: 8

Last Update: January 29, 2009 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

September 11, 2008 10:26:51

sixto.dsilva

Member Since: March 2008 Contribution: 61

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

Data will stored in fact's and dimensional tables the relational database can be Oracle Informatic or netezza it purely depends upon the company which technology they want to go for.

Is this answer useful? Yes | No

January 28, 2009 19:02:42

sharuvijay

Member Since: January 2009 Contribution: 4

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

Data is stored in DW in a relational aggregatted (if needed) denormalized fashion where the data can be easily analysed.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank