Interested to Buy Any Domain ? << Click Here >> for more details...
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 is batch and describe about types of batches?
Suppose we want to display zero when null values coming to report how can we do that?
What is a functional dependency f said to be minimal?
What is surrogate key? Where we use it?
What is the function of surrogate key in data warehousing?
What are the different types of data warehouses?
ware house management system is used?
How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
What is the difference between a primary and secondary actor in use case modeling?
Can we take backup when the database is opened?
What is the difference between power center and power mart?
Explain what is the metadata extension?
What is the difference between er modeling and dimensional modeling?
How can you import tables from a database?
