Forum Discussion

SpikeSpiegel_3's avatar
SpikeSpiegel_3
Frequent Visitor
2 years ago
Solved

Process Add with partitions in SSMS

I created this partition in SSAS (SELECT [dbo].[Dim_Orders].* FROM [dbo].[Dim_Orders] where [DD/MM/YY]>=20190701 and [DD/MM/YY]<=20190930) for Orders table, then I try to use Process Add to only add ...
Need Help
Show and Tell
Tips and Tricks
  • sjoerdvn's avatar
    sjoerdvn
    2 years ago

    If you're using "process add" you need to make sure your query doesn't return any data that has been loaded before. To be honest I don't believe too many people are using "process add", because it requires quite some programming to do this reliable in an operational enviroment.
    You might be better of using incremental refresh.

SpikeSpiegel_3's avatar
SpikeSpiegel_3
Frequent Visitor
2 years ago

I don't think that's the problem because I need to use 'process add' to process only new rows, if I can't use it so how is it even useful ? I mean process full & data processes the whole data and I need only new data. 

sjoerdvn's avatar
sjoerdvn
Solution Sage
2 years ago

If you're using "process add" you need to make sure your query doesn't return any data that has been loaded before. To be honest I don't believe too many people are using "process add", because it requires quite some programming to do this reliable in an operational enviroment.
You might be better of using incremental refresh.