tVerticaOutputBulk
Prepares a file to be used by the tVerticaBulkExec component to
feed a Vertica database.
The tVerticaOutputBulk
component and the tVerticaBulkExec component are generally used together as
parts of a two step process. In the first step, an output file is generated. In the second
step, the file is used in a bulk load operation to feed a database. These two steps are fused
together in the tVerticaOutputBulkExec component. The advantage of using
two separate components is that the data can be transformed before it is loaded into the
database.
tVerticaOutputBulk Standard properties
These properties are used to configure tVerticaOutputBulk running in the Standard Job framework.
The Standard
tVerticaOutputBulk component belongs to the Databases family.
The component in this framework is available in all Talend
products.
connector. The properties related to database settings vary depending on your database
type selection. For more information about dynamic database connectors, see Dynamic database components.
Basic settings
Database |
Select a type of database from the list and click |
Property Type |
Select the way the file path and the schema will be set.
|
File Name |
The path to the file to be generated. This file is generated on the same machine where your Studio is installed or where your |
Append |
Select this check box to add new rows at the end of the file. |
Schema and Edit schema |
A schema is a row description. It defines the number of fields
When the schema to be reused has default values that are You can find more details about how to Click Edit
schema to make changes to the schema. Note: If you
make changes, the schema automatically becomes built-in.
|
Advanced settings
Row Separator |
The separator used to identify the end of a row. |
Include Header |
Select this check box to include the column header to the file. |
Encoding |
Select an encoding method from the list, or select |
tStatCatcher Statistics |
Select this check box to gather the Job processing metadata at the Job level |
Global Variables
NB_LINE |
The number of rows processed. This is an After variable and it returns an integer. |
ERROR_MESSAGE |
The error message generated by the component when an error occurs. This is an After |
Usage
Usage rule |
This component is more commonly used with the tVerticaBulkExec component. Used together, they Talend Studio and the |
Related scenarios
For use cases in relation with tVerticaOutputBulk,
see the following scenarios: