qua_set_reload_mode#
Sets reload mode for given view. Reload mode describes steps to be taken when refreshing the persistent cache.
Syntax#
qua_set_reload_mode 'object', 'mode' [;]
Arguments#
‘cache_mode’
Fully qualified name of view which incremental marker will be changed.
‘mode’
NVARCHAR(20) mode to be set, with one of the following values:
‘full’ = cache cleaned up and reloaded every time.
‘incremental’ = cache is loaded fully only on initial load, after that only new rows are inserted during reload.
Example#
Sets cache mode of view ‘’AdventureWorksDW2012_spark.dbo.DimEmployee’ to ‘incremental’
EXEC qua_set_reload_mode 'AdventureWorksDW2012_spark.dbo.DimEmployee', 'incremental';