qua_full_load_cached_view_copy

Loads cache for given view. Handles all modes of caches changes cache status appropriately as load progresses. For persistent rotated tables cache, switches current after the load is done. Internally it uses many other stored procedures and orchestrates them depending on given view’s cache mode.

Syntax

qua_full_load_cached_view_copy 'view_name' [;]

Arguments

view_name

Fully qualified name of view which cache will be affected.

Example

Loads cache for AdventureWorksDW2012_spark.dbo.DimEmployee.

EXEC qua_full_load_cached_view_copy 'AdventureWorksDW2012_spark.dbo.DimEmployee';