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-4522: A dedicated parser to parse Vertica’s
EXPORT_OBJECTScommand has been added to the Vertica component and is used in its templates.
GEOMETRYdatatype is now supported.
GEOGRAPHYdatatype is now supported.
DI-5715: In the INTEGRATION Vertica template, the Slowly Changing Dimension mode is not efficient and causes memory overconsumption.
DI-5716: The INTEGRATION Vertica template generates duplicate rows on the target table when the Integration Strategy parameter is set to Slowly Changing Dimension mode and the Useless Update Detection Method parameter is set to disable.
DI-5797: In the INTEGRATION Vertica template, the
NOT NULLclauses are unexpectedly hardcoded for the work table columns instead of being automatically computed.
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