Star Schema and Snow Flake Schema

30
19948
star schema
star schema

Friends,

I have never taken and also given an interview on SSAS(even on MSBI) with out the question “What is the difference between STAR and SNOWFLAKE Schema”.  Before going to the differences lets have a look at what a schema is and the types.

Schema in relational database defines the tables, columns in each table, and the relationships between tables. It gives a clear picture about the tables present in the database how the tables are related to each other. There are mainly two types of schema(and ppl are adding one per day like STARFLAKE,GALAXY and so on .. but not to worry much about those) which are listed below.

1) Star

2) SnowFlake.

Lets discuss about each type in detail here.

Star – 

This is the simplest Schema design available and in the star schema design, a single object (the fact table) sits in the middle and is radially connected to other surrounding objects (dimension lookup tables) like a star. Each dimension is represented as a single table. The primary key in each dimension table is related to a foreign key in the fact table. In simple when ALL the DIMENSION TABLES are DIRECTLY related to FACT TABLE then that Schema is called as Star Schema. PFB the Screenshot showing STAR Schema.

 

star schema
star schema

Snow Flake

The snowflake schema is an extension of the star schema, where each point of the star explodes into more points. In a star schema, each dimension is represented by a single dimensional table, whereas in a snowflake schema, that dimensional table is normalized into multiple lookup tables, each representing a level in the dimensional hierarchy. When ALL the dimension tables are NOT directly related to FACT table then that type of schema is called as Snow Flake Schema. PFB Screenshot of Snow Flake Schema.

Snow Flake Schema
Snow Flake Schema

In snow flake schema fact table will be linked directly as well as there will be some intermediate dimension tables or Fact less Fact tables between fact and dimension tables.

That’s it .. Happy Coding !!

Regards,

Roopesh Babu V

30 COMMENTS

  1. Atherosclerosis may reduce NO levels and Rho-kinase activation and may result in loss of smooth muscle from the bladder detrusor and prostate fibrosis associated with loss of bladder compliance and increased urethral resistance, respectively priligy dapoxetine review At some point, you must agree to try cialis in a group setting with someone who is healthy enough to be giving the drug, since you will need to decide what you truly feel about the drug

  2. Also, they d have to arrest the governments of the states of Wisconsin, Minnesota, Illinois, Vermont, as well as many city governments and private employers who have turned north for lower-cost prescription drugs emla cream and priligy tablets Because of this, it s best to use Stendra as close to the time you plan to have sex as possible

  3. Heinrich had an older brother, Gebhard Ludwig Himmler, and a younger brother, Ernst Hermann Himmler safe cialis online Brand Tadarise Composition Tadalafil 20mg Form Tablet Pack Size 10 tablets in strip Packaging Type Box Country of Origin Made in India Tadalafil PDE-5 inhibitor is an active salt in Tadarise 40 Mg tablet which is increases the blood flow to the penis by relaxing the muscles in penile blood vessels hence, treating Erectile Dysfunctioning

  4. Для точной диагностики обращайтесь к специалисту. Капли от глаукомы для роста ресниц нельзя использовать без строгих показаний и консультации с лечащим врачом. 1. Сыворотка для ресниц M.A.C,2. Сыворотка для ресниц Faberlic,3. Восстанавливающая сыворотка для ресниц и бровей Mary Kay. 1 елемент Латисс – раствор, изготовляемый на основе жирной кислоты (биматопроста). Препарат обеспечивает обновление ресничек. Активные вещества проникают в луковицы, тем самым, они стимулируют рост волосков. Средство выпускается в форме флакончика на 5 мл. Его нужно аккуратно распределять по линии роста ресничек, избегая попадания в глаза. Чтобы ресницы были длинными, выглядели красивыми и ухоженными, не обязательно тратить много денег. Для достижения эффектного результата можно использовать недорогие средства для роста ресниц, купленные в аптеке. Головные боли, головокружения, сильная утомляемость, искажение и затуманивание изображения, сложности с восприятием пространства. https://shanerhaq643198.shoutmyblog.com/14276245/mizuho-массажер-против-морщин Nature`s Bounty – Пищевые добавки для поддержания вашего здоровья и красоты Зарегистрированные покупатели получат Карту постоянного клиента Деошоп.ру. Революционная формула усилителя ресниц Revitalash гарантированно борется с проявлениями сухости, ломкости и выпадением ресниц. Увлажняет, смягчает, питает, восстанавливает, укрепляет. Максимально улучшает внешний вид ресниц, делает их густыми и красивыми. Первые результаты видны уже через 2-4 недели ежедневного применения! Благодаря составу, содержащему пептиды и минералы, средство способно разбудить даже спящие луковицы ваших ресниц. Розовый жемчуг и коралл восстанавливают поврежденные ресницы, кардамон усиливает кровообращение и ускоряет рост, а экстракт листьев алоэ защищает от вредного влияния окружающей среды. Революционная формула усилителя ресниц Revitalash гарантированно борется с проявлениями сухости, ломкости и выпадением ресниц. Увлажняет, смягчает, питает, восстанавливает, укрепляет. Максимально улучшает внешний вид ресниц, делает их густыми и красивыми. Первые результаты видны уже через 2-4 недели ежедневного применения!

  5. Try and win big in SCR888 Casino on our superb video poker games. There are a few tricks that could increase the odds of winning games in SCR888 Casino. SCR888 is undeniably the most successful mobile slot games in the recent years. Indulge yourself in SCR888 Casino and gain access to the very best online casino games available straight away to win big! With the SCR888 online and mobile gambling platform, you get the newest and best gaming experience available anywhere. We are an online casino provider in Malaysia that specializes in providing the best online casino applications for users to play and gamble at on the go. Fill in your details below or click an icon to log in: kiosk2.scr888.com                             tm.scr888.com                                              wechat: cs-club88     whatsapp: 0108683043 http://guineapig.org.uk/community/profile/domingawilks027/ Now that you know this, do not get discouraged from using no deposit bonuses! The odds of winning money with a no deposit bonus are lower compared to other bonuses – but you risk less because you can always decide to not deposit anything and to not withdraw the free spins winnings! Please enable Cookies and reload the page. Specializing in Organic Haircare, Non-Toxic Hair Color, Hand Painted Balayage, Blonding, Curly Cuts, Curl Maintenance, and Personalized Treatments. No deposit bonuses are just the beginning of a new player’s Bitcoin casino journey. It is highly likely that the casino offering the NDB will follow up with additional bonuses and promotions including deposit bonuses, VIP rewards, Loyalty bonuses, daily promotions, free spins and so much more. Be sure to keep an eye on your email inbox and mobile notifications to catch new and exciting bonuses that may come your way!

  6. In conjunction with the regulations set out in the act, York Regional Police, working alongside our municipal, regional, provincial and federal partners, will be enforcing violations of the federal act and the provincial regulations, concentrating on the following enforcement responsibilities . The penalties for the two hybrid offences are the same as for alcohol-impaired driving. These include mandatory minimum penalties of a $1,000 fine for a first offence, 30 days imprisonment for a second offence and 120 days imprisonment for a third offence. Canadian Pesticide Mix 3, 100 µg mL in LC MS Acetonitrile If a person ceases to hold a licence, they must, in respect of any document or information that they were required to retain under the Cannabis Regulations and for which the retention period has not yet ended, ensure that the document or information continues to be retained until the end of the retention period and provide the Minister with notice in writing of the address of the location at which the documents or information is retained and of any subsequent change to the address. https://plataformamusic.com/community/profile/valenciaclem486 Cannabis has taken Canada by storm ever since legalization. This is in large part due to the many health benefits and therapeutic effects that come with taking marijuana. Many cannabis users take marijuana products to help treat various medical conditions like stress, anxiety, pain, inflammation, and more. The last time… The largest difference is simply the reason for using cannabis. If you’re using it as medicine, it’s medical marijuana. LowPriceBud is the only top online dispensary in Canada that provides high-quality cheap buds in Canada with fast shipping. You don’t have to compromise on quality to get affordable marijuana. When you buy weed online from LowPriceBud today you get premium cannabis strains for the lowest prices. With our in-house healthcare app developers, app designers, business experts and even compliance consultants, we help you start the online marijuana dispensary from scratch. 

LEAVE A REPLY

Please enter your comment!
Please enter your name here

42 − 38 =