tELTVerticaInput
Provides the Vertica table schema that will be used by the
tELTVerticaMap component to generate the SQL SELECT
statement.
The three ELT Vertica components are closely related, in terms of their
operating conditions. These components should be used to handle Vertica database table
schemas to generate SQL statements, including clauses, which are to be executed in the
database output table defined.
tELTVerticaInput Standard properties
These properties are used to configure tELTVerticaInput running in the Standard Job framework.
The Standard
tELTVerticaInput component belongs to the ELT family.
The component in this framework is generally available.
Basic settings
|
Schema and Edit |
A schema is a row description. It defines the number of fields (columns) to |
|
|
Built-In: You create and store the |
|
|
Repository: You have already created |
|
|
Click Edit schema to make changes to the schema.
|
|
Default Table Name |
Type in the default table name. |
|
Default Schema Name |
Type in the default schema name. |
Advanced settings
|
tStatCatcher Statistics |
Select this check box to gather the Job processing metadata at the Job |
Global Variables
|
Global Variables |
ERROR_MESSAGE: the error message generated by the A Flow variable functions during the execution of a component while an After variable To fill up a field or expression with a variable, press Ctrl + For further information about variables, see |
Usage
|
Usage rule |
tELTVerticaInput is used along with Note:
The ELT components do not handle actual data flow but only schema |