Forum Discussion
Incremental refresh Setup with week start date column in fact table
Hi All, I have a fact table with Sales_week_start_date with date/time data type. I have the below sample data Sales_week Sales_week_start_date 202449 12\01\2024 202450 12\08\...
Thank you for your response. I have already gone through it. But there they have given example based on a date field which is continuous, we can consider calendar and that dates are in sync.So we can understand it easily. But in my case it is weekly data that too with 1 week delay dates. So I am little bit worrying on this.
lbendlin
Super User
Super UserIncremental refresh does not support weekly partitions. Your choices are Day, Month, Quarter and Year.
Use the first day of the week to drive the daily partitions, or use monthly partitions.
Yes. We don't have week option there. But my data gets loaded weekly once at the source, I need to refresh my report weekly.So I have given 7 days. Then what period should I give in the incremental refresh data.