Method: Has Column Value Changed
Function name: HasColumnValueChanged
Parameter list: (columnName)
Return type: Boolean
What the method does: Predefined conversion table. Returns true for the input source column in the current data row if the row is for a replication UPDATE row and the value for the particular column has changed.
This returns true if the column value is being changed either NULL to a value or from an actual value to NULL in addition to the obvious case where there is both an “old” value and a “new” value and they are different.
This method returns false if both the values are the same or both are NULL or either are skipped.
This method returns false if the row operation type is DELETE or INSERT.
This method would be useful to model the data distribution such that rows are replicated to a target table only when the columns relevant to the target table are updated.
The datatypes CHAR, DOUBLE, DECIMAL, and INTEGER are supported.