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
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
What are the steps to be taken to schedule the report?
Explain what three things do you consider to be the most important factors for a manager?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
What Is The Difference Between Oltp And Olap?
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
What three things do you consider to be the most important factors for a manager?
Can Bo generates the Report from the cubical data Explain?
Is there any other repository domains rather than universe, security, document?
Explain about a task that really tested your analytical abilities?
What is the difference between user and versatile user?
U r project in which stage in implementation?
what will be the contents for a functional requirements specifications
What is package in BO
What is the difference between datawarehousing and businessintelligence?