OBIEE Interview Questions part 1


What is the difference between a datawarehouse and a datamart?

http://prashanthobiee.blogspot.in/2012/12/datawarehouse-and-datamart.html

What is an ETL?

http://prashanthobiee.blogspot.in/2012/12/etl-plan.html

What is OLTP and OLAP?

http://prashanthobiee.blogspot.in/2012/12/oltp-and-olap.html

What is a star schema and snowflake schema?

http://prashanthobiee.blogspot.in/2012/12/star-schema-and-snowflake-schema.html

What is ODBC and what is the difference between ODBC and OCI?

http://prashanthobiee.blogspot.com/2012/12/odbc-and-oci.html

Explain Slowly changing dimensions

http://prashanthobiee.blogspot.in/2012/11/slowly-changing-dimension.html

How do you import data from an excel file?

http://prashanthobiee.blogspot.in/2012/11/import-excel-worksheet.html

Define repository in terms of OBIEE
Repository stores the Meta data information. OBIEE repository is a file system and the extension of the repository file is .RPD
·      All the rules needed for security, data modeling, aggregate navigation, caching, and connectivity is stored in metadata repositories.
·      Each metadata repository can store multiple business models. BI Server cannot access multiple repositories.

What are the differences between OBIEE 10g and 11g?
http://prashanthobiee.blogspot.in/2012/11/obiee-interview-questions.html

What is a Confirmed Dimension?
http://prashanthobiee.blogspot.in/2012/11/confirmed-dimension.html

What is Factless fact table?

http://prashanthobiee.blogspot.in/2012/12/factless-fact-table.html

What is a degenerate dimension?

http://prashanthobiee.blogspot.in/2012/12/degenerate-dimension.html

What is an Alias table and why is it used?

http://prashanthobiee.blogspot.in/2012/12/alias-table.html

What is a connection pool and explain its properties

http://prashanthobiee.blogspot.in/2012/11/connection-pool.html

What is use of NQSConfig.ini file?
http://prashanthobiee.blogspot.in/2012/12/nqsconfigini.html

Can you change the location of your rpd file in your OBIEE Configuration? If Yes, Where would you mention the new location of this rpd file for BI Server?

In OBIEE 10g you need to specify it in the NQSConfig.ini 
In OBIEE 11g repository is managed using EM (Enterprise Manager). We can directly specify the path to load the rpd

If you have more than 3 repository files mentioned in you NQSConfig.ini file as default, which one gets loaded into the memory when BI server is started and Why?
Ex:
Star = SamplerRepository1.rpd, DEFAULT;
Star = SamplerRepository2.rpd, DEFAULT;
Star = SamplerRepository3.rpd, DEFAULT;
SamplerRepository3.rpd will be loaded into the memory because as the server starts reading from the top each time it loads the next repository. So finally the last rpd will be loaded into the server memory

What are the minimum services needed to load a repository file onto memory and view a dashboard which has reports that have been refreshed on a scheduled basis?

OC4J(10g) or Weblogic(11g), BI server, Presentation Server, Scheduler server

What are the different places (files) to view the physical sql generated by an Answers report?
NQQuerylog
Administration > Manage Sessions > View Log

Where does the BI Server logs its start, stop and restart times in the file system?
NQServer.log

You have two tables Table 1 and Table 2 joined by a foreign key in the database? They are imported together from the database into your physical layer. Is this relationship still preserved in the OBIEE physical layer?

Yes

Same as the above question but what happens if you import each table separately? 
Keys will be affected but not the joins

If Table 1 and Table 2 are dragged from physical layer to BMM layer, which table becomes a Fact Table and which table becomes a Dimension Table?

Table with primary becomes the dimension table and table with foreign key becomes Fact table

What if the tables (Table 1 and Table 2) are not joined, then what happens in BMM layer?
Both tables act as Fact table

Does OBIEE store physical sql ? How is physical sql generated in OBIEE environments? 
Yes, physical SQL is generated by the query compiler during the query processign of the logical sql

Are there any occasions where physical sql is not generated when running against a backend database like Oracle, SQL Server or any other relational database? 
When the logging level is 0(zero) or when the query log file reaches maximum limit

What is a complex join in OBIEE and why, where is it used?
http://prashanthobiee.blogspot.in/2012/12/complex-join.html

Is it mandatory to have hierarchies defined in your repository? If Yes, where does it help? If No, what happens in the reports?
In OBIEE 10g, it is not mandatory. These are used for drill down and level based measures
In OBIEE 11g it is mandatory, else you get some warnings and errors

How do you create outer joins in physical layer?
We cannot create

What does Consistency Checking perform; What are the minimum criteria to pass consistency checking for a given repository?
One Dimension table and One Fact table

How do we upload new file into BI server in 10g and 11g?
In 10g using NQSConfig.ini
In 11g using EM(EM manages NQSConfig.ini)

How to bypass server authentication?

You can bypass the authentication in NQSConfig.ini and instance config.xml, BYPASS SERVER AUTHENTICATION=YES

What happens when foreign key join is defined in BMM layer?
If a foreign key join is used in BMM layer, then the BI Server will always select this physical join to create the SQL even when it is not most efficient join

When is a complex join used in physical layer?
Complex join is used in a physical layer when we want to use join expressions. For ex: we want to use greater than or less than operator.

What is an implicit fact column?
http://prashanthobiee.blogspot.in/2012/12/implicit-fact-column.html

What is a chronological key?
http://prashanthobiee.blogspot.in/2012/12/chronological-key.html

What is the best default logging level for production users?
Log Level 0

What is the difference between logging level 1 and 2?
Level 1 Logs the SQL statement issued from the client application and logs elapsed times for query compilation, query execution, query cache processing, and back-end database processing.Logs the query status (success, failure, termination, or timeout). Logs the userID, session ID, and request ID for each query.
Level 2 Logs everything logged in Level 1.Additionally, for each query, logs the repository name, business model name, presentation catalog (called Subject Area in Answers) name, SQL for the queries issued against physical databases, queries issued against the cache, number of rowsreturned from each query against a physical database and from queries issued against the cache, 
and the number of rows returned to the client application.

What is the use of  'query repository tool'?
http://prashanthobiee.blogspot.in/2012/12/query-repository-tool.html

What are the different utilities available and explain them in detail


How can I export all the available tables into an excel sheet?

Using the Repository Documentation Utility

Which variable(s) doesn't require an initialization block?

Static Repository Variable

How to model a presentation layer so that all the dimension tables under a Dimension folder and fact tables come under a Fact folder?
To give the appearance of nested folders in Oracle BI Answers, prefix the name of the presentation folder to be nested with a hyphen and a space and place it after the folder in which it nests
Alternatively, you can enter a hyphen and a greater than sign in the description field

If I change a column name in the presentation layer from 'A' to 'A1'. Does the query which includes this column work?
Yes it will work unless you change the column formula

Where can we apply filter in the repository?

In 'where' clause in content tab

What is Authentication and how many types of authentications are available in OBIEE?
Authentication is the process by which a system verifies, through the use of a user ID and password, that a user has the necessary permissions and authorizations to log in and access data. The Server authenticates each connection request it receives. The different authentications available in OBIEE are
  • Operating system autentication
  • External table authentication
  • Database authentication
  • LDAP authentication



















110 comments:

  1. This comment has been removed by the author.

    ReplyDelete
  2. I think the log files are NQQuery.log and NQServer.log but not NQSQuery.log, NQSServer.log.
    Correct me if I'm wrong.

    ReplyDelete
  3. Nice work. keep it up.

    http://obiee-basics.blogspot.in/

    ReplyDelete
  4. Hi, about the location of rpd file .

    Can we change it in 10g because if i read nqsconfig.ini file it clearly says you cant change it.

    or are you talking about clustered enviorment ?

    ReplyDelete
  5. This comment has been removed by the author.

    ReplyDelete
  6. Hi,

    I installed BI Publisher desktop(32 bit) on my system. installation completed successfully. but in word Bi publisher tab not visible.
    in word options : BI Publisher Template builder for Word showing as Inactive application addin.

    OS : Windows7, Msoffice 2007

    Please advice me.
    Thanks,

    Rgds,
    Kulkarni

    ReplyDelete
  7. can u explain diff btwn 11.1.1.6 to 11.1.1.7.0 versions

    ReplyDelete
  8. Nice explanations ...I have all training vids of Obiee11g from experts....harryisin@gmail.com

    ReplyDelete

  9. This is the information that I was looking for and let me tell you one thing that is it is very useful for who is looking for SAS Online Training.

    ReplyDelete
  10. Information which you provided is really helpful.

    ReplyDelete
  11. This comment has been removed by the author.

    ReplyDelete
  12. Moslty asked obiee interview questions and answers suggested by professionals @ https://intellipaat.com/interview-question/obiee-interview-questions/

    ReplyDelete
  13. I am extremely impressed with your writing skills and also with the layout on your blog
    sas training in hyderabad

    ReplyDelete
  14. Great questions, thank you so much for the help! :)

    ReplyDelete


  15. I am extremely impressed with your writing skills and also with the layout on your blog
    Hadoop Online Training

    ReplyDelete
  16. we are offering best Obiee online training with work support and job assistance and high quality training facilities and well expert faculty
    for other details and register your demo contact

    ReplyDelete
  17. ******************************************************
    200 INFORMATICA INTERVIEW QUESTIONS & ANSWERS
    ******************************************************
    http://biinformaticainterviewquestions.blogspot.in

    ReplyDelete
  18. We provide high quality software development services on a broad range of software platforms. All our solutions are based on the new concepts in IT industry such as dynamic reports and integration with mobile applications. This allow us to build wide range of customers across the world.

    The Ultimate IT Solutions in Chennai

    ReplyDelete
  19. This comment has been removed by the author.

    ReplyDelete
  20. Thanks for sharing your post, this is really informative for me. It will help me in future, i appreciate your article!! You can Also visit on : Best Oracle BI OBIEE training in Gurgaon

    ReplyDelete
  21. Thanks for sharing your post, this is really informative for me. It will help me in future, i appreciate your article!! You can Also visit on : Best Oracle BI OBIEE training in Gurgaon

    ReplyDelete
  22. Are you tired of seeking loans and Mortgages,have you been turned down constantly By your banks and other financial institutions,We offer any form of loan to individuals and corporate bodies at low interest rate.If you are interested in taking a loan,feel free to contact us today,we promise to offer you the best services ever.Just give us a try,because a trial will convince you.What are your Financial needs?Do you need a business loan?Do you need a personal loan?Do you want to buy a car?Do you want to refinance?Do you need a mortgage loan?Do you need a huge capital to start off your business proposal or expansion? Have you lost hope and you think there is no way out, and your financial burdens still persists? Contact us (gaincreditloan1@gmail.com)

    Your Name:...............
    Your Country:...............
    Your Occupation:...............
    Loan Amount Needed:...............
    Loan Duration...............
    Monthly Income:...............
    Your Telephone Number:.....................
    Business Plan/Use Of Your Loan:...............
    Contact Us At : gaincreditloan1@gmail.com
    Phone number :+44-75967-81743 (WhatsApp Only)

    ReplyDelete
  23. You have shared informative interview questions with me. Keep updating.
    DBA course syllabus | Oracle dba course

    ReplyDelete
  24. Thanks for sharing this blog. This very important and informative blog for theose who want to know Oracle technology
    Learned a lot of new things from your post! Good creation and HATS OFF to the creativity of your mind.Very interesting and useful blog!

    Best Oracle training in Gurgaon
    Looking forward to your response!
    Thanks & Regards
    Mahesh Chandan

    ReplyDelete
  25. You truly did more than visitors’ expectations. Thank you for rendering these helpful, trusted, edifying and also cool thoughts on the topic to Kate. block chain training in Chennai

    ReplyDelete
  26. This comment has been removed by the author.

    ReplyDelete
  27. Awesome,
    Thank you so much for sharing such an awesome blog...

    video interview software services

    ReplyDelete

  28. Really it was an awesome article… very interesting to read…
    Thanks for sharing.........


    obiee training in ammerpet

    ReplyDelete
  29. hi your blog Article is very nice & thanks for sharing the information.

    obiee online coaching in hyderabad

    ReplyDelete
  30. Nice blog..! I really loved reading through this article. Thanks for sharing such a amazing post with us and keep blogging...


    Best Data Science online training in Hyderabad

    Data Science training in Hyderabad

    Data Science online training in Hyderabad

    ReplyDelete
  31. Wonderful article, very useful and well explanation. Your post is extremely incredible. I will refer this to my candidates...
    Python training in marathahalli
    Python training in pune
    AWS Training in chennai

    ReplyDelete
  32. It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me...
    java training in chennai | java training in bangalore


    java training in tambaram | java training in velachery

    ReplyDelete
  33. I found this informative and interesting blog so i think so its very useful and knowledge able.I would like to thank you for the efforts you have made in writing this article.
    Data Science course in Chennai
    Data science course in bangalore
    Data science course in pune

    ReplyDelete
  34. Nice tips. Very innovative... Your post shows all your effort and great experience towards your work Your Information is Great if mastered very well.

    angularjs Training in btm

    angularjs Training in electronic-city

    angularjs online Training

    angularjs Training in marathahalli

    angularjs interview questions and answers

    ReplyDelete
  35. Great presentation of Obiee form of blog and Obiee tutorial. Very helpful for beginners like us to understand Obiee course. if you're interested to have an insight on Obiee training do watch this amazing tutorial.:-https://www.youtube.com/watch?v=Ajh_ePwlf88


    ReplyDelete
  36. Whatever we gathered information from the blogs, we should implement that in practically then only we can understand that exact thing clearly, but it’s no need to do it, because you have explained the concepts very well. It was crystal clear, keep sharing..
    Web Designing Course in chennai
    PHP Training in Chennai
    Web Designing Institute in Chennai
    Web Designing Training Institutes in Chennai
    PHP Course in Chennai
    PHP Training Institute in Chennai

    ReplyDelete
  37. Howdy, would you mind letting me know which web host you’re utilizing? I’ve loaded your blog in 3 completely different web browsers, and I must say this blog loads a lot quicker than most. Can you suggest a good internet hosting provider at a reasonable price?


    Best AWS Training Institute in BTM Layout Bangalore ,AWS Coursesin BTM


    Best AWS Training in Marathahalli | AWS Training in Marathahalli

    Amazon Web Services Training in Jaya Nagar | Best AWS Training in Jaya Nagar


    ReplyDelete
  38. It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me...

    Guest posting sites
    Technology

    ReplyDelete
  39. This is really too useful and have more ideas and keep sharing many techniques. Eagerly waiting for your new blog keep doing more.
    cloud computing courses in bangalore
    cloud computing training in bangalore
    Aws Training in Bangalore
    Aws Course in Bangalore

    ReplyDelete
  40. Useful information.I am actual blessed to read this article.thanks for giving us this advantageous information.I acknowledge this post.and I would like bookmark this post.Thanks

    python training Course in chennai
    python training in Bangalore
    Python training institute in bangalore

    ReplyDelete
  41. Attend The Python training in bangalore From ExcelR. Practical Python training in bangalore Sessions With Assured Placement Support From Experienced Faculty. ExcelR Offers The Python training in bangalore.
    python training in bangalore

    ReplyDelete
  42. Attend The PMP in Bangalore From ExcelR. Practical PMP in Bangalore Sessions With Assured Placement Support From Experienced Faculty. ExcelR Offers The PMP in Bangalore.
    ExcelR PMP in Bangalore

    ReplyDelete
  43. Hello, I believe your blog might be having browser compatibility issues. Whenever I take a look at your website in Safari, it looks fine however, if opening in IE, it's got some overlapping issues. I merely wanted to provide you with a quick heads up! Apart from that, excellent website!
    Gadgets

    ReplyDelete
  44. The web site is lovingly serviced and saved as much as date. So it should be, thanks for sharing this with us.
    AI Courses
    AI Course in Malaysia
    Artificial intelligence Course in Malaysia
    AI Course

    ReplyDelete
  45. Our knowledge is truly enhanced after reading th8is. It was quite useful. We are truly glad that you shared this with us. Here is a referred link same as yours   oracle fusion financials training. While browsing, I came across this one, it's useful and will be providing necessary knowledge too.

    ReplyDelete
  46. This blog was very nicely formatted; it maintained a flow from the first word to the last. Hank Voight Jacket

    ReplyDelete
  47. Nice post. Thank you to provide us this useful information.
    Superhero Jackets

    ReplyDelete
  48. This comment has been removed by the author.

    ReplyDelete
  49. Want to set your career towards the software field? Then join hands with Infycle Technologies to make this into reality. Infycle Technologies, the best software training institute in Chennai, gives the combined and best software training in Chennai, with various stages of multiple courses such as Big Data, Python, Data Science, Oracle, etc., which will be guided by professional tutors in the field. The Hands-on practical training and the mock interview sessions will be given to the candidates to face the interviews with full confidence. Apart from all, the candidates will be placed in the top MNC's with the highest salary package in the market. To get it all, call 7502633633 and make this happen for your happy life.

    ReplyDelete
  50. Hi , Thank you so much for writing such an informational blog. If you are Searching for latest Jackets, Coats and Vests, for more info click on given link-Harley Davidson Denim Jacket

    ReplyDelete
  51. Best traiing in ChennaiTitle:
    No.1 Oracle Training in Chennai | Infycle Technologies

    Description:
    Learn Oracle for making your career towards a sky-high with Infycle Technologies. Infycle Technologies gives the top Oracle Training in Chennai, in the 200% hands-on practical training with professional specialists in the field. In addition to Oracle training, the placement interviews will be arranged for the candidates, so that, they can set their career without any struggle. The specialty of Infycle is 100% placement assurance will be given here in the top MNC's. To have the best career, call 7502633633 and grab a free demo to know more.

    ReplyDelete
  52. Title:
    Oracle PLSQL Training in Chennai | Infycle Technologies


    Description:
    Learn Oracle PLSQL Training in Chennai for excellent job opportunities from Infycle Technologies, the best Oracle Training Institute in Chennai. Infycle Technologies is the best & trustworthy software training center in Chennai, applies full hands-on practical training with professional trainers in the field. In addition to that, the mock placement interviews will be arranged by the alumni for the candidates, so that, they can meet the job interviews without missing them. For transforming your career to a higher level call 7502633633 to Infycle Technologies & grab a free demo session to know more.
    best training institute in chennai

    ReplyDelete
  53. Infycle Technologies, the best software training institute in Chennai offers the best Python training in Chennai for tech professionals and freshers. In addition to the Python Training Course, Infycle also offers other professional courses such as Data Science, Oracle, Java, Power BI, Digital Marketing, Big Data, etc., which will be trained with 100% practical classes. After the completion of training, the trainees will be sent for placement interviews in the top MNC's. Call 7502633633 to get more info and a free demo.

    ReplyDelete
  54. Want to do a No.1 Data Science Course in Chennai with a Certification Exam? Catch the best features of Data Science training courses with Infycle Technologies, the best Data Science Training & Placement institutes in and around Chennai. Infycle offers the best hands-on training to the students with the revised curriculum to enhance their knowledge. In addition to the Certification & Training, Infycle offers placement classes for personality tests, interview preparation, and mock interviews for clearing the interviews with the best records. To have all it in your hands, dial 7504633633 for a free demo from the experts.

    ReplyDelete
  55. Learn and practice advanced excel Interview questions for the preparation of Data Scientist Interview including questions on VBA, VLOOKUP, VIndex and much more"

    Visit here : Advanced EXCEL Interview Questions

    ReplyDelete
  56. Automated Forex Trading With ETORO REVIEW Metatrader 4 - Download .

    ReplyDelete
  57. Is XM REVIEW Scam? Can They Be Trusted? What Are The Best Brokers? Check Out Our Detailed XM Review And Get The Answers To These Questions And Much More.

    ReplyDelete
  58. Great information about wilderness for beginners giving the opportunity for new people. Baby Driver Jacket

    ReplyDelete
  59. I feel very grateful that I read this. It is very helpful and very informative and I really learned a lot from it.
    full stack web development course in malaysia

    ReplyDelete
  60. This post is so interactive and informative.keep update more information...
    Android Training in Anna Nagar
    Android Training in Chennai

    ReplyDelete
  61. I’m more than happy to discover this website. I wanted to thank you for your time for this particularly wonderful read!!
    I definitely loved every little bit of it and i also have you bookmarked to look at
    new information in your site.lakers jackets

    ReplyDelete
  62. Thank you so much for sharing such a informative and useful blog post. I hope that you and your family will good. I really appreciate you instafasto

    ReplyDelete
  63. This article is incredibly informative! Your insights really clarified things for me. Thanks for sharing this valuable information. I am writing on behalf of EYE CARE CENTER. serving in Houston "eye care near me". Thank you for taking the time to write this topic. Your blog is a valuable resource, and I always look forward to your new posts. Keep up the great work!

    ReplyDelete
  64. iPhone 12 Pro kaufen
    Willkommen bei Phone Palace – Ihrem Online-Shop für hochwertige Apple iPhones, sowohl gebraucht als auch wie neu refurbished. Entdecken Sie erstklassige Qualität, unschlagbare Preise und eine breite Auswahl an verlässlichen Geräten. Ihr zuverlässiger Partner für smarte Einkäufe und nachhaltige Elektronik.

    ReplyDelete
  65. Informative post. Thank you sharing. Please visit our website to learn new courses.

    ReplyDelete

Related Posts Plugin for WordPress, Blogger...