What is a Data Warehouse?

Answer Posted / vijay bhaskar

Data warehouse is integrated,subject oriented,time
oriented,non olatile collection of data to the
decisionmaking system

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain when do we analyze the tables? How do we do it?

612


Can we have multiple application.cfm file in an application?

486


What are the different types of data warehousing?

518


What are the differences between datamart vs. Reporting cube?

489


Explain what are the modules in power mart?

573






What is is a star schema?

567


Explain why should you put your data warehouse on a different system than your oltp system?

513


What needs to be done while starting the database?

656


Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.

1453


In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?

1714


How would you write a left join statement to return a result set of movie.title�s and director.name�s?

518


Explain which columns go to the fact table and which columns go the dimension table?

520


Explain can a dimension table contains numeric values?

567


What are the key columns in Fact and dimension tables?

546


for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?

1676