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.

Querona does not interpret the given value of the marker. 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');