1. What are the differences between a OLAP and OLTP appications
2. What is a star schema?
3. What is a slowly changing dimension?
4. What are the advantages of Extended star schema of BW vs. the star schema
5. What is the namespace for BW?
6. What is an info object?
7. What are the data types supported by characteristics?
8. What is an external hierarchy?
9. What are time dependent text / attribute of characteristics?
10. Can you create your own time characteristics?
11. What are the types of attributes?
12. What is Alpha conversion?
13. What is the alpha check execution program?
14. What is the attributes only lag?
15. What is compounding?
16. What is the Bex options for characteristics like F4 help for query definition and execution?
17. What are the data types allowed for key figures?
18. What is the difference between amount/quantity and number — amount/quantity
19. What are the aggregation options for key figures?
20. What is the maximum number of key figures you can have in an info cube?
21. What is the maximum number of characteristics you can have per dimension?
22. What are the nine decision points of data warehousing?
23. How many dimensions in a cube.
24. What is a SID table and advantages.
25. What are the other tables created for master data?
26. What is the transfer routine of the info object?
27. What is the DIM ID?
28. What is table partition?
29. How many extra partitions are created and why?
30. Can you partition a cube which has data already?
31. What is the transaction for Administrator work bench?
32. What is a source system?
33. What is a data source?
34. What is an info source?
35. What are the types of info source?
36. What is communication structure?
37. What are transfer rules?
38. What is global transfer nile?
39. What are the options available in the transfer rule.
40. Give some important formula available
41. When you do the ABAP code for transfer rule, what are the important variables you use?
42. What is the process of replication?
43. What is the update rule?
44. What are the options in update rules?
45. What are the special conversions for time in update rules?
46. What is the time distribution option in update rule?
47. What is the return table option in update rules for key figures?
48. What is the start routine?
49. How would you optimize the dimensions?
50. What is the conversion routine for units and currencies in the update rule?
51. How do you add an entry in the monitor log from the update rules?
52. What is a data mart?
53. What is the myself data mart?
54. How do you create a data mart?
55. Can you make multi providers and master data as data marts?
56. What are the benefits of data marts?
57. What are events and how you use it in BW?
58. What is an event chain?
59. How do you create event chains?
60. What is PSA?
61. What are the options available for updates to data target?
62. Why if one request fails, all the subsequent requests are turned to "red"?
63. What are the two fact tables?
64. What is compression or collapse?
65. What is reconstruction?
66. What is a remote cube?
67. What is virtual info cube with services?
68. What are the restrictions/recommendations for using remote cube?
69. Give examples of data sources that support remote cubes?
70. What is a multi provider?
71. What are the added features in 3.x for multi provider?
72. What is an info set?
73. What is the difference between multi provider and infoset?
74. Can you create an info set with info cube?
75. What is a line item (or degenerate dimensions)
76. What are the imitations of line item dimension?
77. What is a transactional info cube?
78. What is the cache monitoring transaction?
79. What are the profile parameters for cache?
80. Can you disable cache?
81. What does the program RSMDCNVEXIT check?
82. Can you restart the conversion?
83. When should you do the alpha conversion?
84. Can you make an info object as info provider and why?
85. What are the control parameters for data transfer?
86. What is number range object?
87. How do you set up the permitted characters?
88. What is aggregate realignment run maintenance?
89. What is update mode for master data?
90. What is the ODS object settings?
91. What are the settings for lat files?
92. Which transaction defines the background user in source system?
93. What are non cumulative key figures?
94. Give an example the content key figure OTOTALSTCK (Quantity Total Stock)
95. What is standard and exception aggregation?
96. What is inflow and outflow?
97. What is a "Marker"?
98. What is a time reference characteristic?
99. Give example data sources supporting this?
100. What is the opening balance?
101. What is "No Marker Update"?
102. What are the steps to load non cumulative cube?
103. How does the query calculated?
104. What is a validity determining characteristic?
2. What is a star schema?
3. What is a slowly changing dimension?
4. What are the advantages of Extended star schema of BW vs. the star schema
5. What is the namespace for BW?
6. What is an info object?
7. What are the data types supported by characteristics?
8. What is an external hierarchy?
9. What are time dependent text / attribute of characteristics?
10. Can you create your own time characteristics?
11. What are the types of attributes?
12. What is Alpha conversion?
13. What is the alpha check execution program?
14. What is the attributes only lag?
15. What is compounding?
16. What is the Bex options for characteristics like F4 help for query definition and execution?
17. What are the data types allowed for key figures?
18. What is the difference between amount/quantity and number — amount/quantity
19. What are the aggregation options for key figures?
20. What is the maximum number of key figures you can have in an info cube?
21. What is the maximum number of characteristics you can have per dimension?
22. What are the nine decision points of data warehousing?
23. How many dimensions in a cube.
24. What is a SID table and advantages.
25. What are the other tables created for master data?
26. What is the transfer routine of the info object?
27. What is the DIM ID?
28. What is table partition?
29. How many extra partitions are created and why?
30. Can you partition a cube which has data already?
31. What is the transaction for Administrator work bench?
32. What is a source system?
33. What is a data source?
34. What is an info source?
35. What are the types of info source?
36. What is communication structure?
37. What are transfer rules?
38. What is global transfer nile?
39. What are the options available in the transfer rule.
40. Give some important formula available
41. When you do the ABAP code for transfer rule, what are the important variables you use?
42. What is the process of replication?
43. What is the update rule?
44. What are the options in update rules?
45. What are the special conversions for time in update rules?
46. What is the time distribution option in update rule?
47. What is the return table option in update rules for key figures?
48. What is the start routine?
49. How would you optimize the dimensions?
50. What is the conversion routine for units and currencies in the update rule?
51. How do you add an entry in the monitor log from the update rules?
52. What is a data mart?
53. What is the myself data mart?
54. How do you create a data mart?
55. Can you make multi providers and master data as data marts?
56. What are the benefits of data marts?
57. What are events and how you use it in BW?
58. What is an event chain?
59. How do you create event chains?
60. What is PSA?
61. What are the options available for updates to data target?
62. Why if one request fails, all the subsequent requests are turned to "red"?
63. What are the two fact tables?
64. What is compression or collapse?
65. What is reconstruction?
66. What is a remote cube?
67. What is virtual info cube with services?
68. What are the restrictions/recommendations for using remote cube?
69. Give examples of data sources that support remote cubes?
70. What is a multi provider?
71. What are the added features in 3.x for multi provider?
72. What is an info set?
73. What is the difference between multi provider and infoset?
74. Can you create an info set with info cube?
75. What is a line item (or degenerate dimensions)
76. What are the imitations of line item dimension?
77. What is a transactional info cube?
78. What is the cache monitoring transaction?
79. What are the profile parameters for cache?
80. Can you disable cache?
81. What does the program RSMDCNVEXIT check?
82. Can you restart the conversion?
83. When should you do the alpha conversion?
84. Can you make an info object as info provider and why?
85. What are the control parameters for data transfer?
86. What is number range object?
87. How do you set up the permitted characters?
88. What is aggregate realignment run maintenance?
89. What is update mode for master data?
90. What is the ODS object settings?
91. What are the settings for lat files?
92. Which transaction defines the background user in source system?
93. What are non cumulative key figures?
94. Give an example the content key figure OTOTALSTCK (Quantity Total Stock)
95. What is standard and exception aggregation?
96. What is inflow and outflow?
97. What is a "Marker"?
98. What is a time reference characteristic?
99. Give example data sources supporting this?
100. What is the opening balance?
101. What is "No Marker Update"?
102. What are the steps to load non cumulative cube?
103. How does the query calculated?
104. What is a validity determining characteristic?
No comments:
Post a Comment