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

Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

652


BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...

1811


If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

786


what is xcelsius architecture?

3847


Explain in detail about type 1?

746






Explain what are the measure objects?

641


Differences between business objects and web intelligence reports?

743


What is the difference between the public object&schema object?

675


What is the difference between absolute and relative div positioning?

678


Give some information on report bursting?

647


Can more than 1 metric be applied on an analytic in business objects?

1745


How were the reports scheduled and how to resolve unexecuted documents?

2324


What is package in BO

2801


What is report template in b.o?

661


In banking domain how many Fact tables,Dimension table are present?

8469