MSBI Interview Questions (Part-1)

Session on 06-07-2013(F)

1. Translators?
2. Write back Property?
3. Look up and Example clearly?

Session on 13-07-2013(F)
1. How many languages are used to retrieve data from cube?
2. Degeneration dimensions?
3. write back property
4. Named Calculations and example in real time
5. member,tuple,set definition explain and example
6. Named set
7. Aggregations
8. Creating cube , what challenges u faced
9. How to improve cube performance
10. Before cube creation process methods
11. Datawarehouse
12. Star & Showflake and difference between them
13. MOLAP , ROLAP, HOLAP
14. difference between parellelperiod and periods_to_date
15. YTD,MTD,QTD
16. what is current member
17. what is descendants
18. Drill Through Reports
19. Click Through Reports
20. Drill down Reports
21. sub report
22. one main report and two sub reports exports two in separate excels
23. ssis how to handle errors
24. what are transformations
25. character map transformations
26. blocking and non blocking
27. synchronous and asynchronous
28. hash index
29. Architectures of ssis,ssas,ssrs
30. Top 5 in MDX
31. snap shots

Session on 25-07-2013(F)
1. Types of constraints
2. Triggers
3. Constraints
4. How to initiate the triggers
5. 2nd highest salary of employees
6. ssis _ merge ,In merge any condition is used or not and explain brief example
7. Slowly changes dimension explain
8. Bulk insert task and give example
9. 100 to 1000 records are in database , u retrieve data from 100 to 200 records by using ssis transformations
10. design of cube
11. shared database ---> local database ---> destination tables. How to performs ssis transformations on it.
12. dimensions and fact
13. Check Points
14. How to place Check Points in package level or Task level and briefly explain
15. How about Loggings and types of Loggings