OBIEE INTERVIEW QUESTIONS & ANSWERS Frequently Asked Part 1

1. What are the new featuresadded/changes made in OBIEE 11g compared to OBIEE 10g?
2. How to get SQL from OBIEE Reports?
3. What is Write-Back in OBIEE?
4. How Write Back Works in OBIEE?
5. Example of Write-Back Template inOBIEE
6. What are the limitations of Write-Backin OBIEE?
7. How will you Execute Direct SQL in OBIEE?
8. How will you create report using two subject areas in OBIEE?
9. What are the different PurgingOptions in OBIEE?
10. How to query a repository usingQuery Repository Tool?

How to get SQL from OBIEE Reports?

There are many ways to get the SQL from OBIEE Reports

1. Modify the request and click Advanced in that you get xml code and also the actual SQL.
2. In the catalog Manager click Tools –>Create Report .In the Create Report Window –> Click Request SQL and save the SQL to the physical path in your PC.
3. Enable Loglevel to 2 in the OBIEE Admin Tool from Mange -> Security and enable the log level to 2 by clicking properties for the user, then go to the NQQuery.log in BI_HOME/OracleBI/Server/Logs.You will find the SQL for that User.
4. By clicking Administration ->Manage sessions -> View SQL

Create OBIEE Report Using Two Subject Areas

From the Criteria Pane of the Report Created from First Subject Area come to the bottom of the page and click combine request. But the options are limited for combining like union,minus etc.

Datawarehouse E books (Getting started with Data Warehousing)

Below are some of the top books in Datawarehousing.

• The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling by Ralph Kimball 

• Building the Data Warehouse by W.H.Inmon 

• Mastering Data Warehouse Design: Relational and Dimensional Techniques by Claudia Imhoff , Nicholas Galemmo , Jonathan G. Geiger 

• The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data by Ralph Kimball 

• The Data Warehouse Lifecycle Toolkit by Ralph Kimball, Margy Ross, Warren Thornthwaite, and Joy Mundy 

• Mastering Data Warehouse Aggregates: Solutions for Star Schema Performance by Christopher Adamson 

• Data Warehouse Design: Modern Principles and Methodologies by Matteo Golfarelli and Stefano Rizzi 

• Data Warehouses and OLAP: Concepts, Architectures and Solutions by Robert Wrembel , Christian Koncilia 

• Data Warehouse Toolkit w/WS: Building the Web-enabled Data Warehouse

Regression Testing Phase in ETL Testing

The steps are,

• Ensure that current functionality stays intact whenever new code is released

Performance Testing Phase in ETL Testing

The steps are,

• Verify that data loads and queries are executed within anticipated time frames
• Verify that maximum anticipated volume of data is loaded within an acceptable time frame
• Verify load times with various amounts of data to predict scalability