SCD type 2 in adf | Slowly Changing Dimension Type 2 in Azure Data Factory | adf tutorial part 81

Sdílet
Vložit
  • čas přidán 6. 09. 2024
  • In this video, I discussed about Slowly changing Dimension Type2 using mapping data flows in azure data factory
    SCD type 1 in adf | Slowly Changing Dimension Type 1 in Azure Data Factory | adf tutorial part 80:
    • SCD type 1 in adf | Sl...
    what is realtime working flow in companies in adf | How to work realtime projects in adf | adf 79:
    • what is realtime worki...
    what is git repository and how to use it | GitHub Code Repository for adf | adf tutorial part 77:
    • what is git repository...
    setup azure devops code repository for azure data factory | adf tutorial part 78:
    • setup azure devops cod...
    Azure Data Engineer Interview Questions and Answers | adf real time interview questions | mphasis:
    • Azure Data Engineer In...
    Parse Transformation in Azure Data Factory | Parse Transformation in adf | adf tutorial part 61:
    • Parse Transformation i...
    adf interview question and answer:
    • pwc azure data enginee...
    adf tutorial:
    • Azure Data factory (adf)

Komentáře • 8

  • @RobertLenior
    @RobertLenior Před 9 měsíci +1

    This is so easy to accomplish in SSIS. Why is it still so cumbersome in ADF?

  • @himanshutrivedi4956
    @himanshutrivedi4956 Před rokem +2

    Yes if u upload video with version flag and timestamp that would be better bcj no1 is using isactive only and in my scenario I have 300 columns so I can't right that much big isnull n not isnull logic so pls suggest easy approach and upload new video.. appropriate in advance

    • @ssunitech6890
      @ssunitech6890  Před rokem

      Soon, I'll upload one more video on the same with start and end date

    • @himanshutrivedi4956
      @himanshutrivedi4956 Před rokem

      @@ssunitech6890 better u can add date and version and flag together

  • @user-fr1og6fn7z
    @user-fr1og6fn7z Před rokem +1

    HI BRO i try 2-3 times but doesn't get 0 flags old record its all show 1 in active column

    • @ssunitech6890
      @ssunitech6890  Před rokem

      Watch the video step by step and try to implement, there should be something wrong that you are doing.

  • @chenguangliu5304
    @chenguangliu5304 Před rokem +1

    Where are startDate, endDate, and Surrogate Key columns? These are SCD2‘s key factors, not isActive...