Obiee interview questions

Obiee interview questions
1.Which ETL tool you used for data loading?
2.Name the databases you have worked on?
3.What are the levels of security?
4.What is the difference between Roles and Responsibilities in Siebel.
5.Describe the architecture of Siebel analytics?
6.What are Facts and Dimension tables.
7.what is an initialization block?
8.How to create a dashboard prompt?
9.What is a complex join? Give an example of many to many complex join.
10.Questions regarding datawarehouse.
11.Your role and responsibilities in this project.
12.Questions regarding datamart.
13.What is authentication? In web as well as rpd.
14.what are fact and dimension tables?
15.How did you do Data Level Security and what are the different ways of doing it?
16.What is a snowflake schema and have you worked on it?
17.What are the tasks you did as Analytics Administrator and how?
18.How did you do Cache management?
19.How did you handle security management?
20.How did you do multi-user development environment setup?
21.Were you involved in the design phase and what did you do?
22.How did you do performance tuning?
23.What kind of data source do you have in your project and how did you connect to it?
24.What happens when NQQuery log file is full?
25.Which component schedules, monitors, configure ETL routines? Ans:DAC client.
26.How can you purge the cache?
Ans:a. Use cache manager,
b. setting the Cache Persistence Time in the Physical Table
dialog box for a particular table
c. use event polling tables
27.Can one presentation catalog refer to multiple business models? Ans: No
28.Can multiple presentation catalogs refer to one business model? Ans: Yes
29.What is Dimension Hierarchy
30.What are the types of variables? Give Examples?

1 comment:

Anonymous said...

brillant piece of information, I had come to know about your web-page from my friend hardkik, chennai,i have read atleast 9 posts of yours by now, and let me tell you, your webpage gives the best and the most interesting information. This is just the kind of information that i had been looking for, i'm already your rss reader now and i would regularly watch out for the new posts, once again hats off to you! Thanx a million once again, Regards, obiee training in hyderebad

Top Blogs