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
Give some difference between oltp and olap.
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
Whether dimension table can have numeric value?
What is is a star schema?
what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc
What are algorithms provided by Microsoft in SQL Server?
What is a core dimension?
What are the data types present in bo?
How can we do data cleaning?
Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?
Explain what are the vaious etl tools in the market?
What is a data profile?
After the generation of a report to whom we have to deploy or what we do after the completion of a report?
Explain degenerate dimension table?
What is the difference between aggregate table and materialized view?