Skip to main content

TOP 135 OBIEE INTERVIEW QUESTIONS


During the interview be as cool as possible. Don’t think that is the end.

If you do not click this interview don’t think that’s the end. Be confident while answering the questions. At the same time do not show attitude. Behave as simple as you behave with your friend but your physical appearance should be Formal.

Formal dress, do not make faces, do not shake leg and chair. Sit normal and comfortably but don’t push back the chairs and all.



While starting the Interview Interviewer may ask you

So how are you doing in OBIEE 12C?

Ans: I am good thanks how are you doing in OBIEE 12C?



If the Interviewer did not introduce himself ask him.

I am Sorry I did not get your name in OBIEE 12C?

Interview Question are below prepare for each of them with examples



Q1. Tell me about you and your technical expertise.

Ans: your personal details, with studies job experience and highlighting the projects and your technical skills



Q2. Which versions of OBI/ Siebel Analytics you have worked in in OBIEE 12C?



Q3.Have you worked in Informatica in OBIEE 12C? Which version



Q4. Explain me about your recent Project in OBIEE 12C?

Ans: Explain the Domain of the Project, Company from which you have worked in that project, who is the Client,

Technologies used in this application like OS, Database, OBI, Source Application (Mention as Siebel CRM)



Q5. Have you worked on OBIEE 12C or OBIA in OBIEE 12C?

Ans: OBIA



Q6.What is OBIA in OBIEE 12C?



Q7.What is OBAW in OBIEE 12C?



Q8.What is the Components of OBIEE 12C and OBIA in OBIEE 12C?



Q9.What is the Difference in OBIEE 12C and OBIA in OBIEE 12C?



Q10. Explain the Architecture of OBIA in OBIEE 12C?



Q11. Explain the architecture of OBIEE 12C in OBIEE 12C?



Q12. What have you done in RPD in OBIEE 12C?



Q13. What have you done in Reports what kind of reports / views you have worked in



Q14. Explain about one of the complex situation you have faced in your project and how did you solve that. (While answering Provide Example)



Q15. What is Connection Pool in OBIEE 12C?(While answering Provide Example)



Q16. What do you mean by Shared Log On option in the Connection Pool in OBIEE 12C?(While answering Provide Example)



Q17. How do you create a DSN in OBIEE 12C?



Q18. RPD UserID and Password and Connection Pool user ID Password are usually same or different in OBIEE 12C? Why in OBIEE 12C? (While answering Provide Example)



Q19. What are the Physical Layer Objects in OBIEE 12C?



Q20. Why do you need to create an Alias in OBIEE 12C? (While answering Provide Example)



Q30. How do you create a view in the Physical Layer of RPD in OBIEE 12C?(While answering Provide Example)



Q31. How many Layers are there in the RPD in OBIEE 12C?



Q32. What is the Use of BMM Layer in OBIEE 12C? (While answering Provide Example)



Q33. What is the Use of RPD in OBIEE 12C? (While answering Provide Example)



Q34. What is the use of Presentation Catalogue in OBIEE 12C? (While answering Provide Example)



Q35. RPD is Holds Data or Metadata in OBIEE 12C?



Q36. What is the use of Config.INI File (While answering Provide Example in OBIEE 12C?)



Q37. Where is this file located in OBIEE 12C? (While answering Provide Example)



Q38. Where is the Presentation Catalogue located (While answering Provide Example in OBIEE 12C?)



Q39. How do you enable Cache (While answering Provide Example in OBIEE 12C?)



Q40. What are the other properties that you can set in the Config File (While answering Provide Example)



Q41. Where is Instance Config.xml located and what is the use of this File(While answering Provide Example)



Q42. What is Cache Persistence in OBIEE 12C? Where do you set that in OBIEE 12C? (While answering Provide Example)



Q43. How do you make a table "Cacheable" (While answering Provide Example in OBIEE 12C?)



Q44. Suppose In the Config file I have enabled the Cache still cache is Not generating what could be the possible reason in OBIEE 12C?(While answering Provide Example)



Q45. Based on What criteria or situation a report / query will hit the cache in OBIEE 12C? (While answering Provide Example)



Q46. What do you understand by Cache in OBIEE 12C? (While answering Provide Example)



Q47. What is a Fact Table in OBIEE 12C? (While answering Provide Example)



Q48. What is a dimension table in OBIEE 12C? (While answering Provide Example)



Q49. What is Measure in OBIEE 12C? (While answering Provide Example)



Q50. What is Attribute in OBIEE 12C? (While answering Provide Example)



Q51. What is star schema in OBIEE 12C? (While answering Provide Example)



Q52. What is snowflake Schema in OBIEE 12C? (While answering Provide Example)



Q53. What are the Difference BW OLTP and OLAP in OBIEE 12C? (While answering Provide Example)



Q54. What is Normalized and what is De-normalized in OBIEE 12C? (While answering Provide Example)



Q55. Why the Fact is on the many side and Dimension is at the One Side of a star schema (While answering Provide Example)



Q56. How many LTS can a logical table have in OBIEE 12C? (While answering Provide Example)



Q57. How many Physical Sources a LTS can have in OBIEE 12C? (While answering Provide Example)



Q58. In which scenario you will have more than one logical table source under one logical table in OBIEE 12C? (While answering Provide Example)



Q59. Under which scenario you will have one LTS and More than one Physical Sources inside that in OBIEE 12C? (While answering Provide Example)



Q60. Why do we need to create a complex/logical join in the BMM layer in OBIEE 12C? (While answering Provide Example)



Q61. What is the difference b/w Logical join and Physical Join in OBIEE 12C?(While answering Provide Example)



Q62. One Logical Column can be mapped to how many Physical Columns in OBIEE 12C? (While answering Provide Example)



Q63. One Logical Column can be mapped to how many logical columns in OBIEE 12C? (While answering Provide Example)



Q64. If you create a Logical column based on an existing logical Column, and a similar column based on two physical columns what would be the difference in OBIEE 12C? (While answering Provide Example)



Q65. How do you create a calculated measure in OBIEE 12C? (While answering Provide Example)



Q66. How do you create Dimension Hierarchy in OBIEE 12C? Tell all the steps(While answering Provide Example)



Q67. Why Dim Hierarchy is required in OBIEE 12C? (While answering Provide Example)



Q68. What do you understand about content level of a Fact Table in OBIEE 12C? (While answering Provide Example)




Q69. What do you understand about Granularity of a fact and Dimension table in OBIEE 12C? (While answering Provide Example)



Q70. What is the Significance of providing the content specification in the Fact Table in OBIEE 12C? (While answering Provide Example)



Q71. How do you implement Aggregate Fact Table in OBIEE 12C? (While answering Provide Example) provide all the steps



Q72. Why do we need to use Aggregate table in OBIEE 12C? (While answering Provide Example)



Q73. While implementing aggregate table how many LTS will be there in the logical table in OBIEE 12C? (While answering Provide Example)



Q74. One presentation catalogue can be mapped to how many Business Model in OBIEE 12C? (While answering Provide Example)



Q75. One How many Presentation catalogue can be mapped to one Business Model.(While answering Provide Example)



Q76. How many Types of variables are present in OBIEE 12C? (While answering Provide Example)



Q77. What is the use of Each Type of Variable in OBIEE 12C? (While answering Provide Example)



Q78. What is a Initialization Block in OBIEE 12C? (While answering Provide Example)



Q79. What is a Row Wise Initialization block in OBIEE 12C? (While answering Provide Example)



Q80. What is a Level Based Measure in OBIEE 12C? (While answering Provide Example)



Q81. What is the use of a Level Based Measure in OBIEE 12C? (While answering Provide Example)



Q82. How do you create Level Based Measure in OBIEE 12C? (While answering Provide Example)



Q83. I want to create the Following Measure Explain how you will do that.

# of SR closed in last 14 Days. (While answering Provide Example)



Q84. Want to create a measure.

# Of SR Closed Till Date (While answering Provide Example)



Q85. What is the Time Series Function in OBIEE 12C? How to use Time Series Function. (While answering Provide Example)



Q86. How to create following measure in OBIEE 12C?

# of SR Closed Monthly / No of SR Closed Total



Q87. What is Fragmentation Content in OBIEE 12C? (While answering Provide Example)



Q88. What is Where Clause Filter in OBIEE 12C? Where do you apply such filter in OBIEE 12C? Why do you apply such filter in OBIEE 12C? (While answering Provide Example)



Q89. What is Authentication in OBIEE 12C? What is Authorization in OBIEE 12C? (While answering Provide Example)



Q90. How many type of Authentication are present in OBIEE 12C? (While answering Provide Example)



Q91. What do you mean by Database authentication in OBIEE 12C? (While answering Provide Example)



Q92. What do you mean by External Table authentication in OBIEE 12C? (While answering Provide Example)



Q93. How do you authenticate the users using the variables in OBIEE 12C? What kind of variable you use for this purpose (While answering Provide Example)



Q94. What is the Difference between Non system Session Variable and Dynamic Repository Variable in OBIEE 12C?(While answering Provide Example)



Q95. How do you provide access to different Subject Areas in OBIEE 12C? (While answering Provide Example)



Q96. Can a Group be member of another Group in OBIEE 12C? (While answering Provide Example)



Q97. Suppose a User U1 is member of a Group1. Group1 has access to Subject Area A1. Group1 Does not have access to Subject Area A2, Group1 is member of Group2. Group2 has no Access for Subject Area A2 , but has Access for Subject Area Sa3.

User U1 will have access to which subject Areas in OBIEE 12C? Question from Group Inheritance (While answering Provide Example)



Q98. Want to replace the Null Values as 0 for the Measure Sales Value in OBIEE 12C? How would you do that in OBIEE 12C?(While answering Provide Example)



Q99.What is the difference between Pivot and Tabular report in OBIEE 12C?(While answering Provide Example)



Q100. Why do we need exclude column option in Pivot report in OBIEE 12C? (While answering Provide Example)



Q101. What is section in a pivot table report in OBIEE 12C? (While answering Provide Example)



Q.102 what is Pages in a pivot table report in OBIEE 12C? (While answering Provide Example)



Q103. What is calculated item in a pivot table report (While answering Provide Example in OBIEE 12C?)



Q104. What is conditional formatting (While answering Provide Example)



Q105. I want to compare if actual is greater than the target then we need to highlight the sales rep column how to do this (While answering Provide Example)



Q106. What do you mean by Scope of a Dashboard prompt (While answering Provide Example in OBIEE 12C?)



Q 107. What is Dashboard prompt how to create dashboard prompt (While answering Provide Example)



Q108. Difference between Column selector and View Selector (While answering Provide Example)



Q109. What do you understand by Report Defaults in Dashboard prompt (While answering Provide Example in OBIEE 12C?)



Q110. What is the difference between Dashboard prompt and Global Filter (While answering Provide Example in OBIEE 12C?)



Q111. What is the Difference between dashboard Prompt and Report Prompt (While answering Provide Example)



Q112. How many Type of Graphs are supported in OBI (While answering Provide Example)



Q113. Can we navigate from graph how in OBIEE 12C? (While answering Provide Example)



Q114. How do you navigate from report in OBIEE 12C? (While answering Provide Example)



Q115. I have a parent report with Region and sales. Once i click on a particular Region Value it should drill down to other report with Region and Pending order, for that particular region I clicked on. How to achieve this in OBIEE 12C? (While answering Provide Example)



Q116. What is the difference in Report prompt and dashboard prompt in OBIEE 12C? (While answering Provide Example)



Q117. What is guided navigation (While answering Provide Example in OBIEE 12C?)



Q118. How to attach document in the Dashboard (While answering Provide Example)



Q119. How to Create Combined Request (While answering Provide Example)



Q120. How to use Filter based on another request (While answering Provide Example)



Q121. What is narrative view in OBIEE 12C?




Q122. I want to remove the download to excel option in the dashboard Reports - how (While answering Provide Example)



Edit Dashboard -> select Property of Report -> Select Report link -> uncheck the download option.



Q123. How to create dashboard in OBIEE 12C?



Settings -> Administration -> Manage Interactive Dashboard -> Create Dashboard -> Give the dashboard name and builder to create.



Q124. How to give access to the different dashboards to different groups (While answering Provide Example).



Settings -> Administration -> Manage Interactive Dashboard -> Select Lock Symbol for the specific Dashboard and give access to the users.



Q125. How to deny Permission to use answers to a particular group. (While answering Provide Example)



Settings -> Administration -> Managed Privileges -> Access -> Access to Answers



Q126. What are the major changes in architecture for OBIEE 12C?

Q127) What are the common concepts of multitenant database in OBIEE 12C?

Q128) Methods to create Multitenant Database

Q129) How to convert a normal database to Container enabled database in OBIEE 12C?

Q130) How to create a new PDB database in OBIEE 12C?

Q131)How to distinguish you are in CDB or PDB in OBIEE 12C?

Q132). How to connect to PDB from a CDB in OBIEE 12C?

Q133) How about the datafiles system, sysaux , undo, redo etc , does they create when you create PDB in OBIEE 12C?

Q134) As you said, if SGA and background process are shared, is there any performance impact,

Q135) How does the data dictionary works to manage multiple database, for example if I used PDB1 to select a query from emp.

Q136) How about creating a user in OBIEE 12c in OBIEE 12C?

Comments

Popular posts from this blog

Contact Me

Do You have any queries ?                   If you are having any query or wishing to get any type of help related Datawarehouse, OBIEE, OBIA, OAC then please e-email on below. I will reply to your email within 24 hrs. If I didn’t reply to you within 24 Hrs., Please be patience, I must be busy in some work. kashif7222@gmail.com

Top 130 SQL Interview Questions And Answers

1. Display the dept information from department table.   Select   *   from   dept; 2. Display the details of all employees   Select * from emp; 3. Display the name and job for all employees    Select ename ,job from emp; 4. Display name and salary for all employees.   Select ename   , sal   from emp;   5. Display employee number and total salary   for each employee. Select empno, sal+comm from emp; 6. Display employee name and annual salary for all employees.   Select empno,empname,12*sal+nvl(comm,0) annualsal from emp; 7. Display the names of all employees who are working in department number 10   Select ename from emp where deptno=10; 8. Display the names of all employees working as   clerks and drawing a salary more than 3000   Select ename from emp where job=’clerk’and sal>3000; 9. Display employee number and names for employees who earn commission   Select empno,ename from emp where comm is not null and comm>0. 10

Informatica sample project

Informatica sample project - 1 CareFirst – Blue Cross Blue Shield, Maryland (April 2009 – Current) Senior ETL Developer/Lead Model Office DWH Implementation (April 2009 – Current) CareFirst Blue Cross Blue Shield is one of the leading health care insurance provided in Atlantic region of United States covering Maryland, Delaware and Washington DC. Model Office project was built to create data warehouse for multiple subject areas including Members, Claims, and Revenue etc. The project was to provide data into EDM and to third party vendor (Verisk) to develop cubes based on data provided into EDM. I was responsible for analyzing source systems data, designing and developing ETL mappings. I was also responsible for coordinating testing with analysts and users. Responsibilities: ·          Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business. ·          Understood the requirement and develope