qua_set_incremental_marker

Sets new incremental marker value for given table or view. Value can be later retrieved using function qua_get_incremental_marker.

The given value of the marker is not interpreted. It was designed to be used by user code to support incremental load scenarios.

For example, an incremental marker can hold a date of last change included in cache or some ordinal.

Syntax

qua_set_incremental_marker 'object', 'columnName' [;]

Arguments

‘cache_mode’

Fully qualified name of view which incremental marker will be changed.

‘value’

NVARCHAR(1000) containing new value for given objects’ incremental marker.

Example

Sets and then gets incremental marker for AdventureWorksDW2012_spark.dbo.DimEmployee.

EXEC qua_set_incremental_marker 'AdventureWorksDW2012_spark.dbo.DimEmployee', 'May  4 2017 11:20AM';
SELECT qua_get_incremental_marker('AdventureWorksDW2012_spark.dbo.DimEmployee');