Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
We Were planning to do an Incremental load which is going to perform every week, but we have only Month and Year fields were available.
Source Table from AZURE:
Material,
Plant,
Sales,
Quantty,
Month,
Year
From sql.db.
Could you please let us know how to write incremental script for weekly refresh.
Thanks,
Krish
There is no way to write a true incremental update based on weeks if your data does not include dates or weeks. You could instead write an update that always reads the current and previous months, replacing any previous data for these months. That would be the minimum load period for always getting the previous week if you don't have date or week fields.