Forum Discussion
AmiraBedh
Super User
Super UserUnderstand the incremental refresh partitions
I have a table where I configured fact_transactions (the source is a SQL Server table) the incremental refresh like below : The fact_transactions contains data of a monthly basis trasact...
lbendlinSuper User
Super UserWhen you say "31" days but you are in the last days of August (say, August 30) then "31 days" will also include July 31, which will automatically include ALL days in July - hence 61 partitions. Day partitions are only aggregrated into monthly partitions once they are no longer part of the refresh window.
Switching from "31 days" to "1 month" will reduce the number of partitions from 61 to 2 (ignoring the cold partitions for now)
How many rows are in each of the daily partitions?
AmiraBedhSuper User
Super UserI have data coming each 2nd business day for each month with the transaction date having the same value (as the 2nd business day) about 1000000 rows.
So what do you think ?