10.why we are going to data warehouse?

Answer Posted / vams_gk

for reporting one day details also enough.but analysis
means we need comparision means we need some old data is
called historical data.the data ware house saves historical
data ,we con't to any data base manuplations.


where is in normal databases we arte able to maintain some
extent of data .after that for entering new data u need to
delete the old data.

BUT in Data ware house u are able to stote years of records
no need to delete the old data

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What Is Snow Flake Schema?

668


Tell me a business scenario where I can achieve the data through MINUS only not through subquery.

2607


Explain which versions are used in the bo dashboard work?

635


Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

589


Explain what is the difference between slice and dice and cross tab report?

608






what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?

9882


Explain what sort of existing documents should business analysts refer to when starting on a new project?

605


What is the difference between business requirement document and use case document.

586


What would you consider as your biggest achievement and why?

619


What is the difference between user and versatile user?

585


Differences between business objects and web intelligence reports?

654


Explain what are the steps to be taken to schedule the report?

639


How to open a universe with out using the Designer ??

6616


Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....

1491


What is aggregate table and aggregate fact table ... Any examples of both?

614