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
What is is a star schema?
What are the mapping paramaters and maping variables?
What is execution plan?
Explain what are the advantages of query studio compared to report studio?
How to generate the cubes in framework manager?
Why is dimensional normalization not required?
What are snapshots? What are materialized views & where do we use them?
How to limit the max no of rows retrieved in the report?
What is the difference between snowflake and star schema?
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
Define Data Warehousing?
How much data hold in one universe.
Explain the main differences between star and snowflake schema?
What is a junk dimension? What is the difference between junk dimension and degenerated dimension?
Explain what are non-additive facts?
