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 the use of incremental aggregation? Explain me in brief with an example?
Who needs data warehousing?
How to create context?
In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?
Code the tables statement for a single-level (most common) frequency?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.
Explain some of modeling tools available in the market?
What is metadata in context of a datawarehouse and how it is important?
What are the tools available for etl?
What is the difference between drill through and masterdetail reports?
Is there any default username & pwd for bo designer & supervisor?
What are modeling tools available in the market?
How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?
How are the dimension tables designed?
