Slowly Changing Dimensions In Data warehousing with iPhone 11 Example | SCD 1/2/3

แชร์
ฝัง
  • เผยแพร่เมื่อ 18 ธ.ค. 2024

ความคิดเห็น • 77

  • @divyaaggarwal7824
    @divyaaggarwal7824 2 ปีที่แล้ว +5

    Very well explained, Ankit.
    Will look forward to more DataWarehousing sessions.

    • @kd_witty
      @kd_witty 2 ปีที่แล้ว

      Good ones, Yeah, I am also longing for the DWH Lectures.

  • @ammarkadiwala7755
    @ammarkadiwala7755 ปีที่แล้ว

    Yes, Please make a video on SCD SQL

  • @nidhisingh4973
    @nidhisingh4973 ปีที่แล้ว

    Your all videos are fantastic. Still waiting for more Data warehouse videos

  • @fadwa2413
    @fadwa2413 2 ปีที่แล้ว +2

    Excellent!! looking forward to more DataWarehousing and Modelling sessions

  • @akash4517
    @akash4517 2 ปีที่แล้ว +3

    Thanks Ankit . for starting DWH series .i request you make a video on how to cover kimbell effective way . like important topics it would be great .

  • @radhikasood271
    @radhikasood271 2 ปีที่แล้ว +1

    Thank you for making this amazing video, It solved many of my concepts. Please make video on how to handle SCDs using SQL. Would love to see your approach on this.

  • @amanmishra9407
    @amanmishra9407 2 ปีที่แล้ว +2

    Hi Sir , can you help us with the implementation of type 1 and type 2 SCD records in SQL?
    Thanks in advance

  • @mayankpandey492
    @mayankpandey492 2 ปีที่แล้ว +2

    Plz share video with SQL query explaining about SCD 1,scd2 &scd 3

  • @SanjaySingh-bm4it
    @SanjaySingh-bm4it 2 ปีที่แล้ว

    Please make SQL video as well . Waiting for more Data warehouse videos :)
    Thanks a ton for explaining in such a simple manner

  • @aaravkumarsingh4018
    @aaravkumarsingh4018 2 ปีที่แล้ว

    i am using this scd1 logic for same day update and scd2 logic for different day updates in my organization

  • @abb_raj1107
    @abb_raj1107 2 ปีที่แล้ว +1

    Requesting for more data warehouse lecture videos and also data management videos.Thanks bhai.

  • @swagatikajena9324
    @swagatikajena9324 2 ปีที่แล้ว

    Really thanks a lot..... Very very useful to us 👍🙏

  • @Pasdpawn
    @Pasdpawn ปีที่แล้ว +1

    sir please create a video on implementation. Theory is easy to remember but i was asked how to implement it and i went blank. there are hardly any videos available online which deals with its implementation........ Great work btw

  • @Buzzingfact
    @Buzzingfact 2 ปีที่แล้ว +1

    please make video on scd implementation

  • @DataScienceSchools
    @DataScienceSchools 2 ปีที่แล้ว

    I love your content, because your words are very simple but very effective, and please keep this simplicity, never try to use heavy jargon words so that any one can learn from you.

    • @ankitbansal6
      @ankitbansal6  2 ปีที่แล้ว +2

      This is the only way I know 😊

  • @ganeshkumar1424
    @ganeshkumar1424 2 ปีที่แล้ว

    As usual your explanation rocks .will look forward to more data ware concepts .

    • @ganeshkumar1424
      @ganeshkumar1424 2 ปีที่แล้ว

      Please share sql video explaining SCD concepts ..

  • @siv3331
    @siv3331 2 ปีที่แล้ว +3

    Please post a video on how to implement this SCD type 2 in data warehouse as there is no proper solution found in Google

  • @nareshch1989
    @nareshch1989 ปีที่แล้ว

    Hi Ankit please do more videos on data modeling and SCD.
    Thank you!!

  • @jaivalsartandmore....1199
    @jaivalsartandmore....1199 ปีที่แล้ว

    Very nice explanation; I have requirements for implementing SCD Type 6; could you kindly assist me in understanding SCD Type 6?

  • @pruthvirajkoramoni7991
    @pruthvirajkoramoni7991 2 ปีที่แล้ว

    Excellent explanation.. Please make more videos on data modelling and datawarehousing concepts

  • @krishnakumar-gc6hb
    @krishnakumar-gc6hb 2 ปีที่แล้ว +1

    Requesting more such data warehouse and data modeling videos @ankit

  • @vamsikumar_n
    @vamsikumar_n 2 ปีที่แล้ว

    Excellent explanation

  • @movingcloud5253
    @movingcloud5253 ปีที่แล้ว

    Nicely explained, please create one video on normalisation and its types.

  • @hasnainakbar8621
    @hasnainakbar8621 2 ปีที่แล้ว +2

    Please make SQL video also on this

  • @ashwinimate8470
    @ashwinimate8470 ปีที่แล้ว

    Nicely explained..
    Can you please make video on implementation of scd type in sql..
    Thanks 🙏

  • @soumyasamriddhicoder7365
    @soumyasamriddhicoder7365 6 หลายเดือนก่อน

    Please Make full course videos on data modeling and data warehousing ASAP

  • @gurumoorthysivakolunthu9878
    @gurumoorthysivakolunthu9878 ปีที่แล้ว

    Hi Sir...
    Please make scd type 1, 2 implementation video...
    Thank you...

  • @hritiksharma7154
    @hritiksharma7154 2 ปีที่แล้ว

    Great video . Keep uploading such videos 👍🥺

  • @Brown_Munda_oo7
    @Brown_Munda_oo7 ปีที่แล้ว

    please make a video on this topic
    how to use , where to use in SQL

  • @taniyasaini6830
    @taniyasaini6830 2 ปีที่แล้ว

    Extremely simple and greatly explained!

  • @VivekKumar-dz7ie
    @VivekKumar-dz7ie 2 ปีที่แล้ว

    Too informative, please make more videos like this

  • @jatinyadav8960
    @jatinyadav8960 2 ปีที่แล้ว

    Thank You Bro for such videos hoping for more in data engineering

  • @karangupta_DE
    @karangupta_DE 2 ปีที่แล้ว +1

    Hi Ankit, could you kindly make a video on how to normalise data in OLTP systems.

  • @chinmayamuduli468
    @chinmayamuduli468 ปีที่แล้ว

    This Changes will be updates in data warehouse as data warehouse is read only?

  • @lifeofindians1695
    @lifeofindians1695 2 ปีที่แล้ว

    Please make video on implementation

  • @taniyasaini6830
    @taniyasaini6830 2 ปีที่แล้ว +1

    Can you please also post a video on the various implementation techniques for SCD2 like using merge vs update statements and which one is better?

  • @Raj-ph1py
    @Raj-ph1py 2 ปีที่แล้ว

    Very well explained.
    Thank you

  • @akshaykalamkar8803
    @akshaykalamkar8803 หลายเดือนก่อน

    Then what about Primary key...if we add another row how to handle pk

  • @sumanmondal8836
    @sumanmondal8836 2 ปีที่แล้ว

    Thank you Ankit..can you please make a video on implementation techniques for SCD type 2 in SQL.

  • @ganeshkumar1424
    @ganeshkumar1424 2 ปีที่แล้ว

    Ankit-can you share implementing SCD 2 using SQL .

  • @sudippandit1
    @sudippandit1 ปีที่แล้ว

    Great contents!!

  • @Buzzingfact
    @Buzzingfact 2 ปีที่แล้ว

    thanks for the video, please make more real time Data warehouse videos

  • @IamRavitheja
    @IamRavitheja 2 ปีที่แล้ว +1

    Very good explanation bro, keep adding more important concepts videos for data engineers (DWH and Data Modelling ). Thanks alot for your efforts. Really helpful 💯👍

  • @ashokrajann9351
    @ashokrajann9351 ปีที่แล้ว

    Pls show it how to implement the same in SQL sir

  • @swagatikajena9324
    @swagatikajena9324 2 ปีที่แล้ว

    Please do a video in sql so that we can avoid many transformations in Informatica mappings and in source we can use this query

  • @mohit231
    @mohit231 2 ปีที่แล้ว

    Great video love the explanation
    Please make sql for scd type 2

    • @ankitbansal6
      @ankitbansal6  2 ปีที่แล้ว +2

      Sure

    • @adatalearner8683
      @adatalearner8683 2 ปีที่แล้ว

      Can you also cover some data load situations in SCD2. For example how to address data correction, backfill/replay of data, late arriving data, failed jobs, etc?

  • @ahafeezs
    @ahafeezs ปีที่แล้ว

    Glad to have found your channel Ankit!
    Great explanation of scd 1-3. Do you have plan on making python series about industry tutorial involving Big Data, Data Lake and Data Integration?

    • @ankitbansal6
      @ankitbansal6  ปีที่แล้ว +1

      Yes I will in near future

    • @ahafeezs
      @ahafeezs ปีที่แล้ว

      @@ankitbansal6 awesome, looking forward to it 🤝

  • @venkateshmustipally
    @venkateshmustipally 10 หลายเดือนก่อน

    Well, I'm crossing my fingers for the day Apple decides to generously grace us with iPhones priced at a mere 10k 😅

  • @fatimazahraflaouti7420
    @fatimazahraflaouti7420 2 ปีที่แล้ว +1

    Hi Sir , could you help us with the implementation of type 1 and type 2 SCD records in SQL?
    Thanks in advance