really good content. thanks for the video. and please upload more videos on data loading from a particular source to data ware house step by step. please!!
what if I have multiple table under my Copy activity using for each loop , and each table have different column to identify delta , is that possible or this has to be one table copy at a time
if daily data is coming in my blob storgae I need to insert in my sql tables how to do it automativally. I have 10csv and each csv contains each table details i.e 10 csv and 10 tables in my azuresqldb need to be inserted.
You can create a azure function to be triggered once your storage gets some data. The azure function will invoke the azure data factory which can perform the delta load and archive the csv file. Hope you this answer will help you, please let me know.
If I want all the incremental data in a single file like lets I have done a full load of a table "users" now I want that the Incremental data but in the same file not indifferent date wise file so is that possible.
really good content. thanks for the video. and please upload more videos on data loading from a particular source to data ware house step by step.
please!!
Good one..! Thanks for sharing..👌
Nice video! I have a doubt. Will ADF handle incremental changes on the source DB like Deletes and Updates to the records?
what if I have multiple table under my Copy activity using for each loop , and each table have different column to identify delta , is that possible or this has to be one table copy at a time
Great video! The code for the demo M3 database is not something you would like to share? Thanks!
please upload more videos on azure data factory incremental loading using merge. and how to use dynamic expression s
Good one..!
if daily data is coming in my blob storgae I need to insert in my sql tables how to do it automativally. I have 10csv and each csv contains each table details i.e 10 csv and 10 tables in my azuresqldb need to be inserted.
You can create a azure function to be triggered once your storage gets some data. The azure function will invoke the azure data factory which can perform the delta load and archive the csv file.
Hope you this answer will help you, please let me know.
If I want all the incremental data in a single file like lets I have done a full load of a table "users" now I want that the Incremental data but in the same file not indifferent date wise file so is that possible.
Yes, it is possible by choosing a static file as sink and merge the data into it by using 'Union'.
Please let me know if this helps
Hi Gaurav modi,
Exactly am looking for this requirement is this possible to load the updated incremental changes in same file???