Why do we use DSS database for OLAP tools?

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


Please Help Members By Posting Answers For Below Questions

What is index awareness in universe?

765


What are the reasons to use a chameleon method in data warehousing?

808


What is a data profile?

761


What is is a star schema?

785


Explain a relation schema and a relation?

815


Ist the schema that a data warehouse system can implements.

693


What is metadata in context of a datawarehouse?

726


Explain the structure of cold fusion?

781


What is the goal of optimizer?

773


Whether dimension table can have numeric value?

790


What is application.cfm?

775


How can we run the graph? What is the procedure for that?

708


Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?

715


How to pivot data using informatica when you have variable amount of pivot rows?

703


Is there any default username & pwd for bo designer & supervisor?

786