I am not able to find out any solution how we can do a explicit partition on Fact Table (Internet Sales -> OrderDate). Year and Month (Current, 202503,202502 etc). This parition will help to schedule refresh for current month partition rather doing whole table. For some use case, we can go for last 6 month parition refresh.
If any option available, please let me know which will help a lot.
No CommentsBe the first to comment
