Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Doing Incremental Refresh in Custom Partition

Hello community! I would like to know if you can help my with this one.   Question 1: I have a necessity to create custom partition (by countries) for a fact table in my dataset. But I would like ...
Need Help
Tutorial Requests
  • lbendlin's avatar
    lbendlin
    3 years ago

    Incremental Refresh requires RangeStart and RangeEnd datetime or dateinteger fields.  "Country" is neither (unless you are very creative and map each country to a different date)

     

    You can create custom partitions with the Country criteria but you cannot do incremental refresh on them  (only selective refresh via XMLA).

     

    Data change tracking also requires a (different) datetime field which seems equally inapplicable in your scenario.

lbendlin's avatar
lbendlin
Super User
3 years ago

Incremental Refresh requires RangeStart and RangeEnd datetime or dateinteger fields.  "Country" is neither (unless you are very creative and map each country to a different date)

 

You can create custom partitions with the Country criteria but you cannot do incremental refresh on them  (only selective refresh via XMLA).

 

Data change tracking also requires a (different) datetime field which seems equally inapplicable in your scenario.