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
Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?
What are the tools available for etl?
Explain why denormalization is promoted in universe designing?
Why is dimensional normalization not required?
Is union transormation is active transformation?
i have scheduled a report in a job in the cognos8.3 which would send the reports to the respective user ,now the repot ran and is sent to the respective user but it contains some unwanted data. So based on the senario can any one tell me that can we recall back the report ??????
What is the difference between data warehouse and operational systems?
What are the difference between snow flake and star schema?
Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?
What is the function of surrogate key in data warehousing?
Why we use repository connectivity?
Explain what does level of granularity of a fact table signify?
What is application.cfm?
Explain what is the metadata extension?
How to generate the cubes in framework manager?