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
How to performance tune reports?
Is there any difference in testing database and data ware housing?
Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?
What are session timeout and application timeout? Where we have to do this process?
"A dimension table is wide but the fact table is deep," explain the statement in your own words.
What is a linked cube?
What is surrogate key? Explain with examples.
Explain which columns go to the fact table and which columns go the dimension table?
What is an error log table in informatica occurs and how to maintain it in mapping?
Explain what is full load & incremental or refresh load?
ware house management system is used?
What is data mart in data warehouse?
Why denormalization is promoted in universe designing?
Explain why fact table is in normal form?
Explain what is the metadata extension?