I’ve created a reflection on a VDS that references several physical Oracle tables, and the reflection takes several hours to run. How do I set the refresh policy to to different that the source’s default? Do I have to change the policy on each individual source table?
You’ll have to set the refresh policy on the individual upstream physical datasets. The values set there will override the Oracle source refresh setting. Find the relevant datasets and click on the cog wheel icon next to them. In the window that comes up, you’ll find the Reflection Refresh tab where you can make the relevant changes.
Thanks, Ben. If my query includes six physical tables, do I have to set the policy for all of them or or just one?
And I assume this means I can’t have multiple VDS reflections with different refresh schedules if they reference the same physical tables?