Vertica Component Release Notes
Multiple improvements have been performed to homogenize the usage of Change Data Capture (CDC) in the various Components.
Parameters have been homogenized, so that all Templates should now have the same CDC Parameters, with the same support of features.
Multiple fixes have also been performed to correct CDC issues. Refer to the changelog for the exact list of changes.
A new parameter 'xfieldSep' has been added.
It specifies the hexadecimal code of the Field Separator to be used in the temporary file imported into Vertica.
Examples: 08 = backspace, 09 = tab, 1F = ascii unit separator
|this option is taken into acount only when 'Force Pre Transform File' is set to 'true'. The default value is 08.|
Some issues were encountered when using "usingExportObject" mode for "Create Integration Table Like Target Table" parameter with some Vertica database versions.
Queries have been fixed for this mode to work as expected with the different Vertica database versions.
Expressions used in the various queries to create a row id have been fixed to use the correct syntax.
They were using an order by expression which was not supported by Vertica and not useful.
DI-5797 : Template - INTEGRATION Vertica - the NULL and NOT NULL clauses are unexpectedly hardcoded for the work table columns, instead of being automatically computed.
DI-5716 : Template - INTEGRATION Vertica: Slowly Changing Dimension mode creates duplicated rows on target when the "Useless Update Detection Method" parameter is set to disable.
DI-5715 : Template - INTEGRATION Vertica: Slowly Changing Dimension mode is not efficient and causes memory overconsumption.
DI-1910: Templates updated - New parameter 'Cdc Subscriber' on Templates on which it was not handled yet
DI-1909: Templates updated - New Parameters 'Unlock Cdc Table' and 'Lock Cdc Table' to configure the behaviour of CDC tables locking