Answer Posted / harish
olap tools or reporting tools can be connected to only ONE
database.If we need a report of data from more than one
database like oracle,SQL Server and DB@ then all the data
is put into a datawarehouse database and then the olap tool
can be connected to this datawarehouse database and the
necesarry reports can be generated.
As far as i know this could be a good answer.
Hope this answer helps.
Experts please correct me if i am wrong.
Regards
Harish.
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
Explain what are the different types of join operations?
Explain what is the difference between datawarehouse and bi?
Explain what is the difference between stop and abort?
What are partition points?
Explain the importance of data warehouse?
Explain functional dependency?
Where the applications and where ware house management system is used?
Explain conformed fact?
How to provide security in frame work manager for a query subject?
Explain in detail abt measure objects? And what is the use of it? How to create it?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
What is meta data and system catalog?
Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?
What is the difference between dependent data warehouse and independent data warehouse?
What should I have in mind when building olap solution from scratch?
