Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

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

1864


What are the steps to be taken to schedule the report?

948


Explain what three things do you consider to be the most important factors for a manager?

997


Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?

1133


What Is The Difference Between Oltp And Olap?

1105


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 ?

2041


What three things do you consider to be the most important factors for a manager?

1068


Can Bo generates the Report from the cubical data Explain?

2023


Is there any other repository domains rather than universe, security, document?

1040


Explain about a task that really tested your analytical abilities?

1235


What is the difference between user and versatile user?

1056


U r project in which stage in implementation?

2500


what will be the contents for a functional requirements specifications

2335


What is package in BO

3190


What is the difference between datawarehousing and businessintelligence?

1085