What is Star Schema | Schema for Multi Dimensional Data Model | Data Warehouse

Поделиться
HTML-код
  • Опубликовано: 21 окт 2024

Комментарии • 50

  • @meena.123.
    @meena.123. 7 месяцев назад +25

    *Star schema is also know as starjoin
    * star schema is type of data modeling technich to represent data
    *star schema is multi dimesion data modeling to organize data
    *star schema contains only one fact table or multiples dimesion table
    *star schema can be aplied data warehouse, database, data mart or other tool for organized data
    *all the dimesion are connected to fact table through the forign key
    *primary key of each dimesion table is part of the fact table

  • @SarojKumar-xy9ls
    @SarojKumar-xy9ls 8 дней назад

    superb bhai. pahle mujhe lagta tha online videos are very boring and its a waste of time. par ab lag raha hai mene itne years mein kya kya miss kar diya aur kya wrong concept mere dimag mein chal raha tha.
    Anyway thanks bhai

  • @yash-uy5ym
    @yash-uy5ym 20 дней назад

    Ye sir kitna mast teach krte hai yaar
    Ek raat pehle bacha lete hai har baar

  • @AbhijitZ-yyyy
    @AbhijitZ-yyyy 2 месяца назад +2

    Give this man a oscar!

  • @Mansha_mehandi_art
    @Mansha_mehandi_art 9 месяцев назад +1

    The thumbnail is very good and your way of teaching is super.

  • @sp_9467
    @sp_9467 8 месяцев назад +2

    Watching From Bits Pilani... Great Explanation... Tomorrow is exam

  • @manasishimpi4356
    @manasishimpi4356 Год назад +2

    Accha hua ye video banaye
    Puri playlist chahiye star aur snowflakes ke aur bhi problems lo na solve larke

  • @AdityaSharma-yj8jk
    @AdityaSharma-yj8jk 4 месяца назад +3

    Watching from Harvard University Great explanation. Watching 1 day before the exam 😅😅😅

  • @wamiquesarwar
    @wamiquesarwar Месяц назад

    Very nice explanation

  • @NithishvarMurugesh
    @NithishvarMurugesh Месяц назад

    please add eng subtitle so that other souls can also understand your amazing lecture(I'm one of them who needs it desperately)

  • @deepikasisode
    @deepikasisode Год назад +3

    Need more videos on datawarehouse sir,types of dimensions types of fact table what is confirmed dimensions scenarios on real time basis projects please

    • @GateSmashers
      @GateSmashers  Год назад +3

      Ok will make very soon

    • @deepikasisode
      @deepikasisode Год назад

      @@GateSmashers Thank you sir 🙏, from in which scenarios we go for star and snowflake schema ,in depth pls sir

    • @vector44-k6q
      @vector44-k6q Год назад

      @@GateSmashers hi bring up an affordable course on 60 Questions of IBPS IT officer post

    • @vector44-k6q
      @vector44-k6q Год назад

      @@GateSmashers please do reply in yes or no

    • @aditishrivastava8330
      @aditishrivastava8330 Год назад

      @@GateSmashers sir i have exam please complete the series

  • @BhagatBhutale..
    @BhagatBhutale.. 2 месяца назад

    Video useful

  • @ranjan_v
    @ranjan_v 5 месяцев назад

    Thank you very much

  • @pravintiwari7138
    @pravintiwari7138 2 месяца назад

    Sir please make more videos of data warehouse and mining 😢

  • @AnuMudhale-lj5bs
    @AnuMudhale-lj5bs Год назад +2

    Need more videos on snowflake schema, all types of transformation

  • @Jawariyakhaliq
    @Jawariyakhaliq Год назад +14

    Sir is playlist ko exam sy pehly finish kar dein please 🥺

  • @PrithaMajumder
    @PrithaMajumder 8 месяцев назад +1

    Sir, Thanks a lot for This Amazing Lecture 🙂
    Lecture - 4 Completed ✅ in Data Warehouse Playlist

  • @bestgamingsa497
    @bestgamingsa497 Год назад +14

    First Comment ❤ From Pakistan...

  • @RajneeshDabral
    @RajneeshDabral 5 месяцев назад

    good explanation

  • @vimalradadiya5929
    @vimalradadiya5929 Год назад

    Thank you sir 🙏 for this video
    Excited for more videos on big data topics

  • @technicalsyntax
    @technicalsyntax Год назад

    Good work sir

  • @rampanwar1316
    @rampanwar1316 Год назад

    Great video 💯

  • @nawazmemon-ui6lo
    @nawazmemon-ui6lo 7 месяцев назад

    Thank you sir❤️‍🔥❤️‍🔥❤️‍🔥

  • @ishiqamalik3830
    @ishiqamalik3830 7 месяцев назад

    Sir smart ho gy hn ap😅😅😅

  • @ayyan6061
    @ayyan6061 9 месяцев назад

    Stunning

  • @ShrilekhaJadhavNikam
    @ShrilekhaJadhavNikam Год назад +3

    Employee table primary key is not present in fact table...so no relation between them..pls correct it

  • @ShashankVidap
    @ShashankVidap 7 месяцев назад

    Understood Everything but the only doubt is about the Employee Dimesion i dont find tha is connected to the fact as the other three dimensions are connected with fact whereas there is no foreign key releation of Employee Dimension in the fact table Kindly Help🙏

  • @suparna_saha
    @suparna_saha 7 месяцев назад

    Thanks sir ❤

  • @ShreyashSangle-fu8to
    @ShreyashSangle-fu8to Год назад

    November takh pls almost syllabus cover kar dena DWM ka 🙏end sem me jarurat hogi

  • @souviklaha1260
    @souviklaha1260 Год назад

    sir, thank you😍

  • @kamransayyed5497
    @kamransayyed5497 Год назад

    Helpful ❤️👍🏻

  • @Akhand2207
    @Akhand2207 Год назад

    Sir yadi maine gaye kai leye padha to ibps so it ka syllabus ve ho jayega ya particular hmko ibps so it padhna hoga...#pleasehelp

  • @Tamanna_K_Hardy
    @Tamanna_K_Hardy Год назад +2

    Naina Mem Kaa Birthday hai Naa Aaj To 😏😏😏😎 Wish Kaha Kare 👀

  • @jayeshraokherkar8220
    @jayeshraokherkar8220 Год назад

    🔥🔥🔥

  • @duniyasirfekibaadat6507
    @duniyasirfekibaadat6507 2 месяца назад

    Before 1 day exam 😢

  • @bbi-edu
    @bbi-edu 3 месяца назад

    ruclips.net/video/7x7bW7G_bNY/видео.html

  • @raosahab_123
    @raosahab_123 Год назад +1

    sir ek request h hpsc pgt ka subjective paper ka cource suru krdo