qua_full_load_view_copy

Fills a primary/secondary view copy. Insert statement is executed using the ‘ETL’ Spark scheduler pool.

Syntax

qua_full_load_view_copy 'view_name' [;]

Arguments

‘view_name’

Fully qualified name of the view to materialize.

‘copy’

SYSNAME that can be one of two values: ‘primary’ or ‘secondary’.

Example

Fills primary copy cache for AdventureWorksDW2012_spark.dbo.DimEmployee.

EXEC qua_full_load_view_copy 'AdventureWorksDW2012_spark.dbo.DimEmployee', 'primary';