How is an Extended star schema of BW more advantageous than
the star schema?
Answer Posted / gireesh
1. star schema does not support hierarchy but extended star schema support hierarchy.
2. master data redundency in star schema and in extended star schema there is no masterdata redundancy.
3. In extended star schema master data devided in 3 categories that is
1. md text data
2. md attribute data
3. md hierachy data
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is an event chain?
What are transfer rules?
What are tickets.
Explain the structure of direct update dso?
What are the system tools you can use?
What is Infoset Query?
What internally happens when bw objects like info object, info cube or ods are created and activated?
Where do we use infoset in bi system?
What do you understand by start and update routine?
Do you have any idea how to improve the performance of the bw?
hierarchies are not there in bi?why
where can we find transport return codes
What is start routines.
How does delta update mechanism work in ods?
What are the options when defining aggregates?