05-15-2020 02:53 AM
Learn how you can modernize your (on-premise) legacy data warehouse by leveraging Azure Data Lake and Azure Synapse. You can bring data from your on-premise systems including AX2012 and AX2009. You can easily mash-up data from F&O and legacy systems as well as data from devices and sensors. By using Azure Synapse, you can consume data in the Lake using T-SQL and familiar tools
During Incremental changes, File merging will override the existing file or update the existing file in Azure Data Lake.
Like Existing file = 1000 records,
Incremental file = 3 records,
After the file merging, the data write count will be 1003 or 3 in Azure Data Factory activity data write count?