Forum Discussion
Solved
Incremental Refresh effect on Reference Table
I have set up a 'factTransaction' table, and used the 'sourcedate' for incremental refresh and 'moddateUTC' for the refresh changed data option. I want to aggreagte the table further before load...
It should behave the same in your Dataflow; easy to confirm/try. I think it will work.
Pat
Hi Pat,
Sounds great, I understand this would probably work on the desktop app due to the manual nature of creating the range parameters, but would it work if I modified a dataflow after setting up the incremental refresh?
This is what led me to think about creating a reference table instead of modifying the source table.
It should behave the same in your Dataflow; easy to confirm/try. I think it will work.
Pat