Real time interview questions on OBIEE-1

Tell me About yourself?

This is the major interview question for freshers and experienced. Everyone should prepare before going to the interview.

Experienced: Tell ur name with experience what you have with current and previous organization and then explain the porject what you done. If they expecting more then give your educational details but no need to mention the family back ground.

What are your roles and responsibilities in your current project?

As a OBIEE developer,the reponsibilities like repository configuration and reports generation based on the client requirements. At the end we need to implement the security.

From where you start your work in daily routine?

Daily i got a mail from my reporting manager with a attached document. It includes all the requirements and details of the work. 

What is the architecture of OBIEE?

http://oracletechnotalk.blogspot.in/search?q=OBIEE+architecture

Explain the 3 layers of the repository?

http://oracletechnotalk.blogspot.in/search?q=OBIEE+architecture

What is connection pool and how many connection pools you have in your project?What is the purpose?

Actually connection pool is a link between repository and database. For more details use the link

http://oracletechnotalk.blogspot.in/search?q=connection+pool

We can use multiple connection pools for to increase the performance. The no.of connection pools may dependent on the project. We created different connection pools for

security implementation,users and variables creation etc.

What is the difference between Obiee 10g & 11g?

OBIEE 10g:

• We have 2 joins, foreign key join and complex join.
• We have only level-based hierarchy in the logical layer.
• All the configuration settings will be done at NQSconfig file.

OBIEE 11g:

• we have only 1 join, new join.
• We have different hierarchies; level-based hierarchies, parent-child hierarchies, ragged hierarchies, skipped hierarchies.
• All the configuration settings will be done at the enterprise manager.
• we have option like look-up table.
• In answers,the chart view renamed as graph.

which version of OBIEE you are using?

Go to help in the repository of your project. There we can get the exact version of OBIEE.

What is the difference between OCI and ODBC?

OCI will be specific to the oracle database but the ODBC connection, we can use with any datasource.

Have you ever worked on Joins?If yes how?

Yes, In physical layer i worked on joins based on the data-modelling document.

For more real time interview questions on OBIEE

For more concepts 

creation of hierarchy in OBIEE