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...

please differentiate star schema and snow fleak schema
with dimension table, how end user is depending on them in
creating reports.

Answer Posted / padmalatha0923

star schema: it can be defined as a fact table sorrounded dy dimension tables and all the dimension tables should be de-normalised
snow flake schema: it can be defined as fact tables sorrunded by dimension tables and those dimension tables atleast one dimension table should be normalised

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How we drill up week to month?

1112


What is package in BO

3248


Explain the difference between detect alias and detect context?

1136


what are the tables used in health care domain project and columns used in report?

4556


Tell me a business scenario where I can achieve the data through MINUS only not through subquery.

3129


What is report template in b.o?

1072


What is difference between webi and infoview?

1324


What we need to discuss with designer before starting the universe designing.

2297


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

1051


What is object stores?

1029


What is the difference between slice and dice and cross tab report?

1107


Can we configure two instances of CMS pointing to two different CMS system databases?

2081


Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

1096


If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?

2253


Explain difference between zabo and webi?

1143