You can create Vertica targets in the Target Designer.
You can use relational mode to read large volumes of data from a Vertica source. To read data in relational mode, you must create a Vertica relational connection and configure the session to use a relational reader.
You can use relational mode to update or delete data in a Vertica target. To write data in relational mode, you must create a Vertica relational connection and configure the session to use a relational writer.
When you use bulk mode to write large volumes of data to a Vertica target, you can configure the session to create a staging file. On UNIX operating systems, when you enable file staging, you can also compress the data in a GZIP format. By compressing the data, you can reduce the size of data that is transferred over the network and improve session performance.
You can run sessions on a grid to improve session performance.
The PowerCenter Integration Service can push transformation logic to Vertica sources and targets that use native drivers. For more information, see the
Informatica PowerCenter 9.6.1 HotFix 2 Advanced Workflow Guide