Give me a broad concept of what a data warehouse is, and
what it might be used for?
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 is the guidelines to build universe with better performance? R performance tuning issues of universes?
What is a fact, dimension, measure?
What are the difference between snow flake and star schema?
What are session timeout and application timeout? Where we have to do this process?
What is data mart in data warehouse?
What is many-to-many dimensional model in datawarehousing ?
What is the difference between connected and unconnected stored procedures?
Describe the differences between a data warehouse and data mart.
What is the difference between drill through and masterdetail reports?
What is the main difference between inmon and kimball philosophies of data warehousing?
What is hybrid slowly changing dimension?
What are the different types of segments?
Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?
What is mean by aggregate aware?
What is execution plan?