Mahindra Satyam Interview Questions

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?

Oracle Interview Questions

1) I have one user who is having all three kinds of Role Access (i.e. BI Administrator, Bi Consumer,BI Author)... So what in what will be access of User?

2) What will you do if the Invalid username/password error shows in BI analysis?

3) What is row-wise initialization?

4) I have three columns i.e. customer, month, Revenue? how do you customer column in ascending order in RPD?

5) ave you involved in 10g to 11g upgrade?

6) I have a summary report, in that if i click on one column, then other report should also change accordingly in sync with the summary report

https://www.youtube.com/watch?v=wRSbgEke7kM

Datawarehousing Concepts

https://www.youtube.com/watch?v=1vvAuGwx4Wg

Creating Hierarchies

https://www.youtube.com/watch?v=tEMiwdOmyr8

Cognizant Interview Questions

1) How do you login to BI analytics without using my credentials? and you should create a report/dashboard with my login credentials-- Use Impersonate Concept

2) How to fix the error could not connect to database?

3) can we migrate Presentation layer alone from one server to other server?

4) What is a level based metric?

5) Did work you work on Map viewer Integration?

6) How do you split a table into two tables(if the base table has same set of data)?

7) what is the importance of complex join in BMM model?

8) Which chart is useful in general(horizontal or vertical)?

9) How do you deliver the report through agents to a specific user?

10) How does cache seeding work?

11) What is aggregate Navigation?