Real time interview questions on OBIEE-2

Did u get the data from any other data sources? If yes how?

Yes,ofcourse client will provide the data in different formats like excel sheets, files, cubes etc. We can import the data by creating the drivers for data sources.

Can i import the data directly from other sources to repository?

yes, we can directly import the data to repository

How to set the logging level in repository?

manage->identity->goto the user->set the logging level

The logging level for developer:min 2

The logging level for Administrator:upto 7

In production phase the logging level should be disabled. We can set the logging level for a specific request at answers

Have you ever worked with ETL-tools?

As a reporting developer, i know the flow of ETL process. I never worked on that.The ETL people takecare of everything.

Which type of schema you are used in your project?

Actually most of the projects are designed like a star-schema.My project is also used star-schema as a data model.

What is star and snow-flake schema?

For complete details about star and snow-flake schema

http://oracletechnotalk.blogspot.in/2012/04/what-is-datawarehouse-datawarehouse-is.html

What is fact and dimension table?

The detailed description of fact and dimension tables

http://oracletechnotalk.blogspot.in/2012/04/what-is-datawarehouse-datawarehouse-is.html

What is the flow of your porject?

Every project must follow the software development life cycle.

Generally,the porject flow may like requirements gathering, Development(ETL and Report), testing and Production.The flow of project may differ from project to project based on domain like retail, telecom, healthcare, construction etc.

The complete knowledge on SDLC

http://oracletechnotalk.blogspot.in/2012/04/obiee-application-development-life.html

What is Dataware housing?

http://oracletechnotalk.blogspot.in/2012/04/what-is-datawarehouse-datawarehouse-is.html

Rate yourself in SQL?

OBIEE developer must have the knowledge on sql because he need to test his own stuff.Minimum knowledge of SQL is required for dataware housing developers.The rating should be dependent on the person knowledge.

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