Incremental Loads Using Row Version

When using a rowversion column in Sql Server to track incremental loads it is recommended to convert the rowversion field to a Varchar to be able to store it in the metadata repository. At times it may be beneficial to convert this back to a binary value at run time to take advantage of indexes on that field. The $incremental_ss_binary kodda(<column name>)$ function can be used to do this.

The screenshots below show a custom expression created on the version column in order to track changes and the use of the $incremental_ss_binary kodda(<column name>)$ function to control how the query is written against the database.