OBIEE Interview Questions

-

1. Query for top 5 emps from 10 dept tables
2. Purpose of Alias and duplicate tables, how do use them, explain them with a scenario
3. What is Usage Tracking and how do we implement that
4. Implicit Fact Tables
5. You have 4 Dimensions how will you create a Pivot Table View
6. Pre-requisites for OBIEE Installation
7. How do you implement Snowflake Schema in your RPD
8. What is the toughest issue which you face during your Answers development ? ANS: While preparing a simple report with 2 dims & 1 Fct, data is not populated in a column, reason is there is a (chr32) in one  of the dimension values and we have used the same as filter in the report
9. How do you improve performance of OBIEE
10. A user should not able to view a particular table / column while preparing answers
11. In a snow flake schema a Dimension Table D1 is mapped to D2 and inturn Dimension D2 is mapped to Fact F1, in this case how can you show your report with D1 & F1 data
12. How & Why did you implemented Aggregate tables
13. Have you used Aggregate Pesistance wizard, why & how ?
14. How do you improve performance during you ETL process ? How do you debug when there is performance issue.
15. Level Based Measures
16. Difference between Physical Aggregate table which we create manually in DB & Aggregate table created through Aggregate Persistance Wizard
17. Can you develop a RPD without any Hierarchy ?

Comments

Post a Comment

Popular posts from this blog

Steps to Deploy the OFSAA application in WEBLOGIC server:

-
Steps to Deploy the OFSAA application in WEBLOGIC server: ========================================================= 1) Generate the "context_name.ear" from the FIC_WEB area by executing the ./ant.sh 2) Create a folder by the name "applications" within the domain directory 3) Create a folder by the name "context_name.ear" within the newly created "applications" folder 4) Copy the context_name.ear file from the FIC_WEB folder to the newly create the "context_name.ear" folder created within the applciations folder 5) Explode the .ear file copied from the FIC_WEB area (jar -xvf context_name.ear), There are 2 files and 1 directory created after the .ear file is exploded as mentioned below a) context_name.war ---> file b) context_name.ear ---> file c) META_INF ---> folder 6) Delete the above files (.ear and .war files) 7) Create a new folder by the name "context_name.war" 8) Copy the context_name.war file from th
Read more

Client / Server Applications

-
What is: The client–server characteristic describes the relationship of cooperating programs in an application. The server component provides a function or service to one or many clients, which initiate requests for such services. Advantages: * In most cases, a client–server architecture enables the roles and responsibilities of a computing system to be distributed among several independent computers that are known to each other only through a network. This creates an additional advantage to this architecture: greater ease of maintenance. For example, it is possible to replace, repair, upgrade, or even relocate a server while its clients remain both unaware and unaffected by that change. * All data is stored on the servers, which generally have far greater security controls than most clients. Servers can better control access and resources, to guarantee that only those clients with the appropriate permissions may access and change data. * Since data storage is centralized, update
Read more

Steps for OFSAA ALM cash flow generation

-
Please find the steps below for the OFSAA ALM cashflow generation. -------------------------------------------------------------------------------------------------------------- 0. OBJECT REGISTRATION 1. Create Product Hierarchy in front end.--- DIM_PRODUCTS_B 2. Create COA hierarchy in the front end. -- dim_common_coa_b 3. Map product members to COAs 4. Create one Legal Entity in the Front end. 5. Execute "Reverse Population" -- DT name : REVERSE_POPULATION 6. Create one Active Time bucket. 7. Populate DIM_DATE : Execute function "" in the back end with start date and end date. 8. Populate FSI_D_LOAN contracts 9. Create one product characteristic in ALM 10. Create one ALM Static Deterministic process for Loan data. 11. Execute from ALM Process. 12. Use the below queries for cashflow data. select /* + PARALLEL(16)*/ a.as_of_date, a.account_number, a.amrt_type_cd, a.int_type, a.origination_date, a.last_reprice_date, a.next_reprice_date, a.ma
Read more