One of our source databases, an ERP system in production, has a column under the name time stamp that services as an incremental column for all of the tables present in the DB.
I have noticed the JDBC incremental load component chooses the following strategy due to the data type of the increment column.
"Source table is "XXXXXXXXXXXX"
Incremental column is TIMESTAMP with type varchar.
Unable to perform an incremental load on this column, running a full load instead."
Is there a way to use the timestamp column as an incremental column?