Vertica Component Release Notes
Change Data Capture (CDC)
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.
Load File to Vertica (with copy)
New parameter xfieldSep
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.|
Fix creation of temporary integration table when "usingExportObject" is used
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.
Fix expressions used for generating a row id
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.
Version 5.3.5 (Component Pack)
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.
Version 3.0.0 (Component Pack)
Version 2.0.4 (Vertica Component)
Version 2.0.3 (Vertica Component)
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