1) I have three columns
Customer Month Amount
XYZ jan 10
ABC feb 20
DEF Mar 30
ABC May 40
XYZ Jan 50
ABC feb 60
How to see the cumulative sum of amount by month wise for each customer?
2) Differences between 10 g and 11g ?
3) What is Partitioning?
4) What is fragmentation?
5) What is Rank and Dense Rank. Tell me the difference b/w them
6) Have you created Indexes on Columns?
7) What is bitmap and Btree index?
8) What is a composite key?
9) What is a surrogate key? tell the importance of surrogate key?
10) I have 5 departments, so I want to see the highest earned employee in each Department? Frame a SQL query?
11) What is a primary key?
12) What is KPI?
13) Have you implemented Usage tracking?
14) What are agents?
15) How do resolve unique constraint error in informatica?
16) Have you worked on building new mappings?
17) What is DAC?
18) Can we use primary key -foreign key join in BMM layer?
19) How do you set permissions on dashboard page?
20) Why do you use aggregate tables?
21) Why do we use content level?
22) What are different types of hierarchy in OBIEE 11g?
23) What is ragged and skipped hierarchy?
Customer Month Amount
XYZ jan 10
ABC feb 20
DEF Mar 30
ABC May 40
XYZ Jan 50
ABC feb 60
How to see the cumulative sum of amount by month wise for each customer?
2) Differences between 10 g and 11g ?
3) What is Partitioning?
4) What is fragmentation?
5) What is Rank and Dense Rank. Tell me the difference b/w them
6) Have you created Indexes on Columns?
7) What is bitmap and Btree index?
8) What is a composite key?
9) What is a surrogate key? tell the importance of surrogate key?
10) I have 5 departments, so I want to see the highest earned employee in each Department? Frame a SQL query?
11) What is a primary key?
12) What is KPI?
13) Have you implemented Usage tracking?
14) What are agents?
15) How do resolve unique constraint error in informatica?
16) Have you worked on building new mappings?
17) What is DAC?
18) Can we use primary key -foreign key join in BMM layer?
19) How do you set permissions on dashboard page?
20) Why do you use aggregate tables?
21) Why do we use content level?
22) What are different types of hierarchy in OBIEE 11g?
23) What is ragged and skipped hierarchy?
