1. What are the main important differences between olap and oltp

2. Discus two reasons why feeding data into OLAP system directly from the source operational system is not recommended

3. Which are the OLAP tools available that are supported by Oracle?

4. What is the difference between analysis and synthesis?

5. What are the tools used for data analysis in DHW especially where Data Stage is being used as the ETL tool?

6. I am loaded with questions as I am an experienced ETL coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of NON EMPTY so that I don't see r

7. What is the Service name for Microsoft SQL Server Analysis Services 2000?

9.What is the difference between Business Requirement Document and Use case Document. What is the difference. I need a good BRD and UC template.

10.What is Data Warehouse