Best practices to implement incremental data load into azure data lake & azure data warehouse

Question

I am planning to implement azure BI. I need expert advice on how to implement incremental data load using azure data lake, azure sql datawarehouse, azure data factory + poly base. In which format, we should store data in azure data lake etc.

Thanks Nutan Patel

Answer 1

This question is a bit broad so will probably get closed on that basis. There is however an article you should read called: Azure SQL Data Warehouse loading patterns and strategies:

https://blogs.msdn.microsoft.com/sqlcat/2017/05/17/azure-sql-data-warehouse-loading-patterns-and-strategies/