Thursday, 8 August 2013

OBI Developer Interview Questions

Interview Questions:

1) Can we create a report without Repository?

2) What is the use of ROW_WID?

3) Difference between Duplicate table and Alias Table?

4) Explain about MUD?

5) What are different types of Security?

6) How do you implement Data levle security?

7) What are Ibots?

8) Have you implemented Performance tuning techniques?

9)  What is a level based Hierarchy? Explain few examples?

10) What are variables? and how many types?

11) Explain a scenario where you used Static and Dynamic varaibles?

12) What is difference between single LTS and Mulitple LTS?

13) Scenario: We have a report which picks data from one dimension, one fact table(W_AP_XACT_F) &
one aggregate table table(W_AGG_AP_Invoice)
 Question: Will the report pick data from Aggragate or Fact Table

14) What are different types of Authentication?

15) Can we implement Exteranl Table authorization with LDAP authentication.

16) We two fact tables and one dimension, so I want to pick data particular fact and its corresponding dimension? But its throwing Error?

17) How do you configure Financial Analytics?

18) Explain Different cache mechanisms?

19) What is a Application Role?

20) Can't we create users and Groups in RPD in obiee 11g?

21) How do you implement Object level and Data level security using Session Variables?

22) Whatr is LDAP Authentication? How to configure it?

23) How do you migrate RPD and Reports( From one Instance to Other Instance)?

24) How do you give estimates to business on new enhancements?

25) Give me few examples of Confirmed Dimensions?

26) What is the difference between Logical Key and Chronological key?

27) What is Chasm Trap model?

28) Have you worked on SSL?

29) Have you worked on upgradation of OBIEE 10g to OBIEE 11g?

30) Have you worked on BIAPPS project or Standalone Application?

31) What are the modules you have worked in BIAPPS?

32) To what level you have done the Customizations to Prebuilt reports?

33) Have you implemented Writeback Functionality?





No comments:

Post a Comment