what is difference between star schema and extend star
schema?
Answer Posted / suprakashmay nandi
a. Use of generated keys(numeric) for faster access.
b. Externa hierarchy
c. Multilanguage support
d. Master data common to all cubes
e. Slowly changing dimension supported.
f. Aggregates in its own table for faster access.
| Is This Answer Correct ? | 14 Yes | 7 No |
Post New Answer View All Answers
What is an infocube? What are its different types?
What are the hierarchy relevant parameters?
What are the parameters available in user exit for enhancing master data?
Explain ods?
What are the general restrictions?
How do you convert from LIS to LO extraction?
What are the settings for Transport?
What are the general services supported?
What are value fields?
How do you enter data in real-time infocubes?
Where to check the log for warning messages appearing in activation of transfer rules?
How will you configure BW to load data from data stages?
What is a control query?
What are the options when defining aggregates?
What is partitioning and what are the benefits of partitioning in an infocube?