Distribute the load across Vertica initiator nodes - Connect_ETL - Latest

Connect ETL Vertica Load Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect (ETL, Sort, AppMod, Big Data)
Version
Latest
ft:locale
en-US
Product name
Connect ETL
ft:title
Connect ETL Vertica Load Guide
Copyright
2025
First publish date
2003
ft:lastEdition
2025-05-21
ft:lastPublication
2025-05-21T18:34:10.033000

After the data is loaded to the nodes of the Vertica database, Vertica distributes the load across the data nodes using an optimization strategy known as projections. Vertica recommends that you enable automatic projections initially. Later, you may choose to use the Vertica Database Designer to manually create projections that optimize your database based on the characteristics of the data and, optionally, the queries you use.

For information on Vertica projections, see the “Automatic projection creation” topic in the Configuring the Database section of the Vertica Enterprise Administrator’s Guide.