Oracle OBIEE Interview Q & A
3/5
()
About this ebook
This book contains Actual Oracle OBIEE Interview Q & A.
It contains Q & A on the following Topics :
Repository Basics
Building Physical , BMM & Presentation Layer
Testing & Validating a Repository
Creating Dimension Hierarchies & Level Based Measures
Using Partitions & Fragments
Using Repository Variables
Modeling Time Series , Security & Cache Management
Mohammed Azizuddin Aamer
Md Azizuddin Aamer is an MBA currently working as a Sr. Project Manager for a large MNC. He got 9 + Years of Siebel CRM Experience. He has worked on all versions of Siebel ranging from Siebel 5.5 to Siebel 8.1. He is PgMP Certified from PMI , PMP Certified from PMI , PRINCE 2 Certified , ITIL Certified and Stanford Certified Project Manager ( SCPM ) from Stanford University. He is Siebel 7.7 Certified Consultant as well as Siebel 7.7 Analytics Server Architect Certified. Author of more than 60+ Siebel books ranging from Technical Topics to Functional Topics.Books are mostly sold as e-books on www.pothi.com as well as www.amazon.com and lulu.com
Read more from Mohammed Azizuddin Aamer
Salesforce.com Interview Q & A & Certification Question Bank with Answers Rating: 4 out of 5 stars4/5Siebel Clinical / CTMS Guide Rating: 4 out of 5 stars4/5Siebel Insurance 8 Guide Rating: 4 out of 5 stars4/5Siebel Remote Administration 8 Blackbook Rating: 0 out of 5 stars0 ratingsSiebel Incentive Compensation Management ( ICM ) Guide Rating: 0 out of 5 stars0 ratingsSiebel Asset Based Ordering ( ABO ) Rating: 2 out of 5 stars2/5
Related to Oracle OBIEE Interview Q & A
Related ebooks
Oracle Cloud A Complete Guide - 2019 Edition Rating: 0 out of 5 stars0 ratingsOracle Cloud Applications A Complete Guide - 2019 Edition Rating: 0 out of 5 stars0 ratingsOracle Cloud Infrastructure Third Edition Rating: 0 out of 5 stars0 ratingsOracle SOA BPEL Process Manager 11gR1 A Hands-on Tutorial Rating: 5 out of 5 stars5/5Oracle Modernization Solutions Rating: 0 out of 5 stars0 ratingsOracle CPQ Cloud Complete Self-Assessment Guide Rating: 0 out of 5 stars0 ratingsThe Business Analyst's Guide to Oracle Hyperion Interactive Reporting 11 Rating: 5 out of 5 stars5/5Oracle E-Business Suite The Ultimate Step-By-Step Guide Rating: 0 out of 5 stars0 ratingsOA Framework Beginners Guide Rating: 0 out of 5 stars0 ratingsORACLE 12C Complete Self-Assessment Guide Rating: 0 out of 5 stars0 ratingsOracle Application Framework A Complete Guide Rating: 0 out of 5 stars0 ratingsOracle HCM Cloud A Complete Guide Rating: 0 out of 5 stars0 ratingsOracle Fusion A Complete Guide - 2020 Edition Rating: 0 out of 5 stars0 ratingsOracle Essbase 11 Development Cookbook Rating: 0 out of 5 stars0 ratingsOracle CRM On Demand Administration Essentials Rating: 0 out of 5 stars0 ratingsOracle ADF 11gR2 Development Beginner's Guide Rating: 0 out of 5 stars0 ratingsOracle API Management 12c Implementation Rating: 0 out of 5 stars0 ratingsPro Oracle SQL Development: Best Practices for Writing Advanced Queries Rating: 0 out of 5 stars0 ratingsOracle Business Intelligence Enterprise Edition 12c A Complete Guide - 2020 Edition Rating: 0 out of 5 stars0 ratingsOracle E-Business Suite R12 Core Development and Extension Cookbook Rating: 0 out of 5 stars0 ratingsOracle E Business Suite A Complete Guide - 2020 Edition Rating: 0 out of 5 stars0 ratingsMicrosoft Dynamics NAV 7 Programming Cookbook Rating: 0 out of 5 stars0 ratingsMastering IBM WebSphere Portal: Expert Guidance to Build and Deploy Portal Applications Rating: 4 out of 5 stars4/5Oracle HCM Cloud The Ultimate Step-By-Step Guide Rating: 0 out of 5 stars0 ratingsWS-BPEL 2.0 Beginner's Guide Rating: 0 out of 5 stars0 ratingsOracle CPQ A Complete Guide - 2019 Edition Rating: 0 out of 5 stars0 ratingsOracle Data Guard A Clear and Concise Reference Rating: 0 out of 5 stars0 ratingsOracle Essbase 9 Implementation Guide Rating: 0 out of 5 stars0 ratingsOracle Fusion Complete Self-Assessment Guide Rating: 4 out of 5 stars4/5Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook Rating: 0 out of 5 stars0 ratings
Enterprise Applications For You
Scrivener For Dummies Rating: 4 out of 5 stars4/5Excel : The Ultimate Comprehensive Step-By-Step Guide to the Basics of Excel Programming: 1 Rating: 5 out of 5 stars5/5Systems Thinking: Managing Chaos and Complexity: A Platform for Designing Business Architecture Rating: 4 out of 5 stars4/5Excel 2019 For Dummies Rating: 3 out of 5 stars3/5Creating Online Courses with ChatGPT | A Step-by-Step Guide with Prompt Templates Rating: 4 out of 5 stars4/5Excel Formulas and Functions 2020: Excel Academy, #1 Rating: 4 out of 5 stars4/5ChatGPT Ultimate User Guide - How to Make Money Online Faster and More Precise Using AI Technology Rating: 0 out of 5 stars0 ratings50 Useful Excel Functions: Excel Essentials, #3 Rating: 5 out of 5 stars5/5Bitcoin For Dummies Rating: 4 out of 5 stars4/5QuickBooks 2023 All-in-One For Dummies Rating: 0 out of 5 stars0 ratingsQuickBooks Online For Dummies Rating: 0 out of 5 stars0 ratingsCreate Income through Self-Publishing: An Author's Approach on Generating Wealth by Self-Publishing Rating: 5 out of 5 stars5/5Excel 2016 For Dummies Rating: 4 out of 5 stars4/5Excel Formulas That Automate Tasks You No Longer Have Time For Rating: 5 out of 5 stars5/5QuickBooks 2021 For Dummies Rating: 0 out of 5 stars0 ratingsLearn Windows PowerShell in a Month of Lunches Rating: 0 out of 5 stars0 ratings101 Ready-to-Use Excel Formulas Rating: 4 out of 5 stars4/5Enterprise AI For Dummies Rating: 3 out of 5 stars3/5Notion for Beginners: Notion for Work, Play, and Productivity Rating: 4 out of 5 stars4/5CISSP Study Guide Rating: 4 out of 5 stars4/5102 Useful Excel 365 Functions: Excel 365 Essentials, #3 Rating: 0 out of 5 stars0 ratingsExcel : The Complete Ultimate Comprehensive Step-By-Step Guide To Learn Excel Programming Rating: 0 out of 5 stars0 ratingsExercises and Projects for The Little SAS Book, Sixth Edition Rating: 0 out of 5 stars0 ratingsLearning Python Rating: 5 out of 5 stars5/5The Ridiculously Simple Guide to Google Docs: A Practical Guide to Cloud-Based Word Processing Rating: 0 out of 5 stars0 ratings
Reviews for Oracle OBIEE Interview Q & A
1 rating1 review
- Rating: 3 out of 5 stars3/5Hi Its Very nice and easily understanding
Book preview
Oracle OBIEE Interview Q & A - Mohammed Azizuddin Aamer
Chapter : Repository Basics
1.What are Clients ?
Ans:-
Provide access to Business Intelligence Information:
Oracle BI Answers
Is a set of graphical tools used to build , view , and modify Oracle BI requests
Oracle BI Interactive Dashboards
Display the Results of Answers Requests and other items
Oracle BI Administration Tool
Is used to build an Oracle BI repository
2.Describe Oracle BI Presentation Services ?
Ans:-
Provides the processing to visualize the information for client consumption
Is implemented as an extension to a Web server
Uses a Catalog to store saved content
Receives Data from Oracle BI Server and provides it to the client that requested it.
3.Describe Oracle BI Server ?
Ans:-
Is the core server behind Oracle Business Intelligence
Provides efficient processing to intelligently access physical data sources and structure information
Uses metadata to direct processing
Generates dynamic SQL to query data in the Physical data sources
Connects natively or through ODBC to the RDBMS
Structures results to satisfy requests
Provides BI data to Oracle BI Presentation Services
4.Describe Oracle BI Repository ?
Ans:-
Stores the metadata used by the Oracle BI Server
Is accessed and configured using the Oracle BI Administration Tool , which you use to:
•Import metadata from databases & other data sources
•Simplify & reorganize the metadata into business models
•Structure the business model for presentation to users who request information.
5. Describe the Physical Layer ?
Ans:-
•Contains objects representing the physical data sources to which the Oracle BI Server submits queries
•May contain multiple data sources
•Is typically the first layer built in the repository
6.Describe BMM Layer ?
Ans:-
Is where Physical schemas are simplified & reorganized to form the basis of the users view of the data.
7.Describe Measures ?
Ans:-
•Are the facts a business uses to evaluate its performance
•Can be calculations defining measurable quantities
•Are created on logical columns in the fact table
•Have a defined aggregation rule
8.Describe Presentation Layer ?
Ans:-
•Contain Presentation objects that provide a customized view of a business model to users
•Simplifies & organizes the business model to make it easy for users to understand & query
•Exposes only the data meaningful to users
9.Describe Repository Modes ?
Ans:-
•Offline Mode
•Online Mode
Offline Mode
•Oracle BI Server is not started
•Repository is not loaded into Oracle BI Server memory
•Used for development
Online Mode
•Oracle BI Server is started
•Repository loaded into memory
•Users can submit query requests
Chapter : Building the Physical Layer of a Repository
What is a Database Object ?
Ans:-
•Is the highest-level object in the Physical layer
•Defines the data source to which the Oracle BI Server submits queries
What is Connection Pool ?
Ans:-
•Defines how Oracle BI Server connects to a data source
•Specifies the ODBC or native data source name
•Allows multiple users to share a pool of data source connections
What is a Schema folder ?
Ans:-
Is an optional display folder that contains tables & columns for a physical schema
To create a schema folder , right-click a database object and Select New Object > Physical Schema
What is a Physical Column ?
Ans:-
•Is an Object that corresponds to a column in a physical database
What is a Key Column ?
Ans:-
Defines relationship between tables
Primary key
•Uniquely identifies a single row of data
•Consists of a column or a set of columns
•Is identified by a Key Icon
Foreign Key
•Refers to the primary key columns in another table
•Is composed of a column or set of columns
Chapter : Building the Business Model & Mapping Layer of a Repository
Describe Business Model ?
Ans:-
•Is the highest-level object in the Business Model & Mapping Layer
•Contains the business model definitions & the mappings from logical to physical tables
•Simplifies the physical schema
•Captures how users think about their business using their own vocabulary
What are Logical Tables ?
Ans:-
Represent Fact or dimension data
Can be Created :
•Automatically by dragging tables from Physical layer
•Manually by right-clicking business model & selecting New Object > Logical Table
Can be modified without affecting Physical Layer Objects
What