tELTMysqlInput
Adds as many Input tables as required for the most complicated Insert
statement.
The three ELT Mysql components are closely related, in
terms of their operating conditions. These components should be used to handle Mysql DB
schemas to generate Insert statements, including clauses, which are to be executed in
the DB output table defined.
tELTMysqlInput provides the table schema to be used for
the SQL statement to execute.
tELTMysqlInput Standard properties
These properties are used to configure tELTMysqlInput running in the Standard Job framework.
The Standard
tELTMysqlInput component belongs to the ELT family.
The component in this framework is available in all Talend
products.
Basic settings
Schema and Edit |
A schema is a row description, it defines the nature and number of Click Edit
|
 |
Built-in: The schema is created and |
 |
Repository: The schema already exists |
Default Table Name |
Enter the default table name, between double quotation marks. |
Advanced settings
tStatCatcher Statistics |
Select this check box to collect log data at the component |
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 |
tELTMysqlInput is to be used along Note:
Note that the ELT components do not handle actual data flow but |