Interested to Buy Any Domain ? << Click Here >> for more details...
10.why we are going to data warehouse?
- 4 Answers
- 11782 Views
- Satyam, TCS, I also Faced
- E-Mail Answers
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 anyone tell me how to display (calculate )Turn Around Time between two dates in the BO Report? Thanks in Advance
why you create universe and creating reports based on that? why dont we go for crystel reports and generate reports directly?tell me the advantages?please answer to this question.
Explain what would you consider as your biggest achievement and why?
What are the steps to do to use alerts in bo?
What is difference between webi and infoview?
can any one say me exactly when and where alias and context are used in resolving a loop. If possible try to give me a scenario also.
WHAT TYPE OF JOINS RETURNS INCORRECT RESULTS?
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
how many times can use the union operator in a report?
Can any body will explain about sarrogat key? Thanks in advance...........Prakash
What is the difference between Thin client & thick client?
How to link one location universe to other location universe
Teradata 
