51. Copy Incremental data from ADLS to Azure SQL DB

Поділитися
Вставка
  • Опубліковано 5 січ 2025

КОМЕНТАРІ • 11

  • @LifeofTraveller-vo7zk
    @LifeofTraveller-vo7zk Рік тому

    Very much helpful. Great explanation. Thanks 👍👍👍

  • @sraoarjun
    @sraoarjun Рік тому +1

    Very good video yet again and to the point !!

  • @a.a_2878
    @a.a_2878 Рік тому +4

    The solution works on the small data sets but not when there are millions of rows in the source, and you are required to incrementally load every hour. You simply cannot afford truncate load million rows every hour.

  • @narendrakishore8526
    @narendrakishore8526 10 місяців тому +1

    Without lookup activities it looks better approach

  • @rahulkumarchaurasia5962
    @rahulkumarchaurasia5962 7 місяців тому +1

    Hello Sir, my target source is csv , than how can load incremental in csv

    • @cloudanddatauniverse
      @cloudanddatauniverse  7 місяців тому

      You can't load incremental in same CSV file like you do for a table, you will always have to do full load for csv

  • @KaraokeVN2005
    @KaraokeVN2005 10 місяців тому +1

    Great Video!!!!!!!!!

  • @chandandacchufan3242
    @chandandacchufan3242 7 місяців тому +1

    not a great solution - cant everytime do truncate and load in to sql db and again from query u can't do query