Interested to Buy Any Domain ? << Click Here >> for more details...
Give me a broad concept of what a data warehouse is, and
what it might be used for?
- 2 Answers
- 5204 Views
- I also Faced
- E-Mail Answers
Answer Posted / phani kumar
Any organization keeps track of data and the current data
is only relevant to the OLTP means Online transaction
processing.
Suppose a company maintains sales data of different areas
for a particular product and it wants to know, whether a
particular area is having good sales or not.
For this it has to work on the past data for the sales made
at a particular area.
For making strategic decisions at a higher management level,
analysis needs to be made not on the historical data, which
is being maintained in the datawarehouse.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is the data type of the surrogate key?
Explain if a flat file cotains 1000 records how can I get first and last records only?
What needs to be done when the database is shutdown?
What is real-time datawarehousing?
What are the different types of fact tables used in data warehousing?
What needs to be done while starting the database?
List down some of the real time data-warehousing tools?
What are the fundamental elements of the data warehouse?
Explain why fact table is in normal form?
Which columns go to the fact table and which columns go the dimension table?
Explain difference between view and materialized view?
Explain what are fact, dimension, and measure?
How many types of facts and what are they?
Explain reference cursor?
What is cfapplication tag?
