Data Warehousing SAP MicroSoft Java Oracle Testing WebSphere Advanced

OBIEE Interview Questions and answers for Experienced

Published by admin On August 14, 2014

Home Data Warehousing

OBIEE Interview Questions and answers for

Experienced

Question.1 What is single LTS and multiple LTS?

Answer: The logical table created at the BMM layer can be based on the data from a single physical layertable, when it is called single Logical Table source. When the specific logical layer table is dependent on thecolumns of different physical layer tables, it is called Multiple LTS. Most of the time we will be dealing withMultiple LTS.

Question.2 If we have 5 different dimension tables and we need to have hierarchies for

only one table, is it mandatory to have hierarchies implemented for all the tables?

Answer: No, it is not mandatory to create the hierarchies for all the tables, we can just define hierarchies tothose tables that need to have it.

Question.3 How is the Query repository tool used?

Answer: The Query repository tool gives the option to search and analyse the data from the database

Search here..

Demo Vid

19 OBIEE Interview Questions and answers for Experienced http://learn.bigclasses.com/obiee-interview-questions-and-answers-for-experienced

1 of 7 1/8/2015 1:17 AM

Question.4 What are opaque views in database? When is it advisable to create one?

Answer: The opaque views are tables that are created with join or other query data that contain SELECTquery output. The opaque views make the logical understanding simple for implementation but there are heavyperformance constraints. They are only used when there is no other way to get to the final solution.

Question.5 How does the user of Aggregate tables help you in speeding up query

responses? How is Siebel Analytics Server advantageous in this aspect?

Answer: The Aggregate tables are the ones that get values initialized in them as and when the related fieldsin the other tables get updated. This type of automatic updates to frequently used measures help you inspeeding up the queries. If there is a column for number of products produced for every month and you oftenwant to have the summation of the number per year and average for every year often for all the queries, theaggregate table created will have the option to give you that value without computations every time. SiebelAnalytics server gives the added advantage that the queries need not be aware of the readily availableaggregate table names. If this was the case the SQL queries and the entire design might become complex.

Question.6 What is an implicit fact column?

Answer: The implicit fact column is the one that is created due to the join, combinations from the different dataor columns from the different tables. There may not be the exact data in form of the column in the result or evenin the physical layer of database. These are implied from different data and can just be a temporary layer whichhelp us in getting the required result.

Question.7 How can you map each of the reports across to the different tables that are

being accessed?

Answer: The Admin tool has the Manage Sessions tab which gives you the access to the logs that are beinggenerated for each session.After the report generation sessions, you can easily view the log to map eachrequests to the corresponding tables and databases.

Question.8 How can you migrate the presentation layers across to different servers? 9+1=?

Qu

Interview Q & A BigClasses Blog Reviews

19 OBIEE Interview Questions and answers for Experienced http://learn.bigclasses.com/obiee-interview-questions-and-answers-for-experienced

2 of 7 1/8/2015 1:17 AM