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');