10.why we are going to data warehouse?
Answers were Sorted based on User's Feedback
Answer / g.v.subramanyam
data warehouse is used for to store the large volumes of
data.it can be used for future forecasting.it is the
collection of key pieces of information that can be used for
to take the dession by the managers.
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / handy
The main aim of data warehouse is in analyzing the large
volumes of data so that it can be helpful in taking business
decisions
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / 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 |
Answer / nameer
Datawarehouse(OLAP):
To store historical or years of data, we use datawarehouse.
So it will be usefull for managerial people to analyse
theire current scenario with old one and take some usefull
decision in the future to improve their business.
We load the data into datawarehouse using some ETL tool
which is called datawarehousing where as in normal database
we use insert operation. in datawarehouse no delete,update
or insert operation is used. Only select operation is used.
It uses the dimensional modelling(star or snowflake) schema
which will speed up the retrieval of data comapred to
ordinary database.
Is This Answer Correct ? | 0 Yes | 1 No |
Can you please send me the migration related issues .
What is the sheduling the report? What is the need of sheduling the report?
I have saved one file in GMT as a standard time and the server must convert it into local time. How to do it?
Table A, Table B is there, that colums are different like tabl A contian (A varchar(9), B varchar(2), date), table B contian(D varchar(10), E varchar(2), F date) , i want 2 compare mismath datatype length in both table, how? do you know any in built function?
What is broad cast agent?
What is the functional & architectural differences between business objects and web intelligence reports?
Approximatly how many enduser can use the each bo project?
Can anybody tell me what are the tuning problems?
how to limit number of rows in a report in business objects using webi?
Hi , iam beginer in the Boxi . I am getting errors when i applying the @promtps and functions. I want alredy created universe and i absorve the things how those were applied . is it possible to get it throug internet? if it is possible could u plz help me? anandh1110@gmail.com
Can any one gve me the complete information abt Certfication of Business Objects ?
1. I have 2 universes. that is u1 and u2. From u1,i created one report that is r1. Now i want to give the connection r1 to u2 and at the same time delete the connection from u1 to r1 ? How is it possible explain? 2.How can i schedule the reports in BOXIR2?