Nagadevi Kavali

• Oct 19th, 2006

 

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

elektra

• Oct 19th, 2006

 

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.

Brave

• Nov 9th, 2006

 

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

madhu

• Nov 27th, 2006

 

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.

Ram

• Dec 5th, 2006

 

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

Ofcourse it is relational but format differs

tacklu

• Mar 1st, 2007

 

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

sixto.dsilva

 Profile Answers by sixto.dsilva Questions by sixto.dsilva

• Sep 11th, 2008

 

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.

sharuvijay

 Profile Answers by sharuvijay Questions by sharuvijay

• Jan 28th, 2009

 

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