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 Snow Flake Schema design in database?

Answer Posted / swamy.l.n

1.IN A STAR SCHEMA IF A DENORMALIZE DIMENTION TABLE SPLITED
INTO ONE OR MORE DIMENTION TABLE RESULTS IN THE
NORMALIZATION OF DIMMENTION TABLE.
2.SINCE THE D-BASE DESIGN LOOKS LIKE A SNOW FLAKE
STRUCTURE.IT IS KNOWN AS SNOW-FLAKE(OR)STAR-FLAKE.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to provide security in frame work manager for a query subject?

1007


Explain are data mart and dwh normalized or denormalized? Do both of them exist in

1081


What is latest version of power center / power mart?

1143


What is many-to-many dimensional model in datawarehousing ?

988


Explain what is a cube in data warehousing concept?

1027


Explain what are the different methods of loading dimension tables?

993


What is VLDB?

1112


What are aggregate transformation?

1092


How to test report in reportnet?

1052


Explain me what is vldb?

980


How to export mappings to the production environment?

948


What is a data profile?

1024


Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?

1017


Database in use is oracle?

1105


Explain hybrid slowly changing dimension?

1062