what is difference between star schema and extend star
schema?
Answer Posted / aviroop
Star schema is a special case of snowflake schema. Here,
the fact table is surrounded by dimension master data
tables inside the Cube. Bt its extended schema version
further breaks up the dimension tables of star schema into
dimension Id table and master data table. It simplifies and
increases the database accessibility for other cubes to
make it more robust.
| Is This Answer Correct ? | 7 Yes | 5 No |
Post New Answer View All Answers
when u creating infoobject it shows reference and template what is it
In real world when do you recommend aggregate?
What is scoring ?
What is data ware-housing hierarchy?
What does rollup do?
Can you add programs in the scheduler?
Does any other erp software use bw for data warehousing.
What is the process chain?
Explain about the multi-provider in the sap?
What is delete table before extraction option?
How will you configure BW to load data from data stages?
Explain about ods?
What is the format of LO data sources?
What are the data target administration tasks?
In keyfigure what is meant by cumulative value, non cumulative value change and non cumulative value in and out flow.