what is difference between star schema and extend star
schema?
Answer Posted / dhalpathi
in star schema dimension and master data table are same.
in extend star schema dimension and master data table are
different.( master data outside the cube and dim..table
inside cube). in star schema we can analyis only 16 angle.
but in ex..star schema we can analyis 16*248 angle.
| Is This Answer Correct ? | 93 Yes | 14 No |
Post New Answer View All Answers
What is the conversion routine for units and currencies in the update rule?
What is the procedure to create a data mart?
is it possible to avoid special characteristic in infocube level permanently?
How many types of info sources are there? What are they?
how client access the reports
What are the Oracle specific tuning should be done?
how would you do the unloading non-cumulative cubes.
What is rowlevel security ? can u please explain with real time example?
hierarchies are not there in bi?why
how the master data is read?
What is the library?
What is the process chain?
I created process chain 1st day it taking 10 min after that 1st week it taking 1 hour after that next time it taking 1 day with a same loads what happen how can u reduce the time of loading
What is the difference between ods and infocube and multiprovider?
What is CO-PA retraction?