what is the difference b/w star and snowflack schema in
dataware house?
Answer Posted / thava
Star schema is one fact table in the middle is sorrounded
by many dimension tables and no extenssion for the dimensin
table it means denormalized.
Snowflake schema is where the dimension table is extended
to normalized form
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is the difference in creating filters in designer and business objects?
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.
What is thumbnail?
What Is Snow Flake Schema?
Explain when to use local filter and when to use global filter?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
What is difference between webi and infoview?
How would you format some text using css to be verdana and bold?
is it possible to export the webi reports to crystal reports?with out using businessview?
In banking domain how many Fact tables,Dimension table are present?
What is the difference between user and versatile user?
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
What Is The Difference Between Oltp And Olap?