33 Interview Questions on Oracle Business Intelligence, OBIEE Job Interview Questions.
- How comfortable are you in Siebel tools to get the understanding of the Tables and joins?
- Explain the Data Modelling Fundamentals and Concepts Different Types of Data modelling (Physical & dimensional)
- What are the different utilities in OBIEE. Explain about the Admin tool, ODBC client & catalog.
- What are Joins & Keys in OBIEE Layers ie. Physical & Bus , creation of Aggregation Tables(Hierarchy,summary,sources)
- What are the different stages of working in Analytics Repository
- Datawarehouse Basics & ETLETL (A,b,c into x (a,b,c ->different Data sources) how to achieve by writing oracle procedure
- Explain about the Visiblity Model in OBIEE.
- How is advanced formatting achieved in OBIEE. How do you achieve Conditional Formatting of Reports.
- What is a Physical SQL, NQQuery Log, NQS Config. INI, Cluster Config ?
- Explain the difference between Integrated and Stand Alone Analytics
- Explain the hierarchy of the OBIEE Web components.
- How is the Event polling and purging done in OBIEE?
- How do you add a New dimension to the Existing DataMart
- Is Data model changed in Newer version of OBIEE .Why and what measures needs to be taken while upgrading.
- Ibot fails and gives odbc error in Production - How to prevent the error in delivering to the recipient?
- How to Create the report and what are the standards followed to do the same
- What is Star and Snow Flake schema. where snow flake can be used and which uses what schema (OLAP and OLTP)
- What is Image Prompt and column Prompt in siebel answers
- How a logical request works in OBIEE
- Explain about the Performance Tuning techniques applied in the OBIEE.
- What is OBIEE clustering? How fail over recognizes the other server
- Explain properties of connection pool, multiple connection pools to the same Database
- What is a Narrative View and Styles applied to charts and different view available in OBIEE
- Explain the process of upgrade of a old web cat to a new Web cat After the new installation of OBIEE
- Disconnected Who uses it and steps in configuring Disconnected application
- How to Bypass the Repository Authentication ?
- Which triggers the ETL and how data is refreshed ?
- What is a Corelated sub query, Derived Tables ?
- Explain what do you mean by Normalization and the five different normal forms
- What is the primary key, foreign key, alternate key, composite key and candidate key ?
- How do you bring data at run time from other database ?
- What is Meta data?Do we actually have database or is data stored in meta data
Related Posts
No comments :