Thursday 17 January 2013

OBIEE INTERVIEW QUESTIONS & ANSWERS Frequently Asked Part 1

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.

Wednesday 9 January 2013

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
Related Posts Plugin for WordPress, Blogger...

ShareThis