Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between star schema and extend star
schema?
- 11 Answers
- 50561 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / binu v. rajan
in star schema master data tables are inside the cube.
demerit of star schema
limited analysis is possible since only 16 master data
table can be accommodated in a cube.
alpha nummerical values are getting posted in fact table
that may degrade the perfomence.
master data table cant reuse for any other cubes.
in ext. star schema
Surrogat id tables are genearated with the activation of
master data table. based on sids dimention id will genarate
and the dimention id will get posted in fact table.
so charactorstic value will not be there fact table insted
did's and kf will be there.
master data table can be re used since its out side of the
cube.
3224 master data table can be used in fact table through
dimention table.
| Is This Answer Correct ? | 13 Yes | 19 No |
Post New Answer View All Answers
How would you convert an info package group to a process chain?
how would you re-assign to proper component?
How would you measure the size of a infocube?
what do you mean by update routines
What is the use of rollup?
What is transfer routines.
When a query is run with a loop, what does it generate? A) Cartesian product b)An incompatible combination of objects c) An SQL statement generation error d)Results returning too many rows e)Results returning too few rows
Where do you store your custom images (like logos)?
You want to start an implementation project. List the steps you would take to gather the requirements.
What is the table filled when you select ABAP?
How can I configure the workflow so that when the deadline is missed the workflow step is simply skipped?
Define the upgrade steps to 3.x?
What is persistence mode in cache?
explain return tables. How do start routine and return table synchronize with each other?
What are different types on virtual providers?
