tELTNetezzaOutput
Performs the action (insert, update or delete) on data in the specified Netezza
table through the SQL statement generated by the tELTNetezzaMap
component.
The three ELT Netezza components are closely related, in terms of their
operating conditions. These components should be used to handle Netezza database table
schemas to generate SQL statements, including clauses, which are to be executed in the
database output table defined.
tELTNetezzaOutput Standard properties
These properties are used to configure tELTNetezzaOutput running in the Standard Job framework.
The Standard
tELTNetezzaOutput component belongs to the ELT family.
The component in this framework is generally available.
Basic settings
Action on data |
On the data of the table defined, you can perform the following Insert: Adds new entries to the table. Update: Updates entries in the table.
Delete: Deletes the entries which |
Schema and Edit |
A schema is a row description, it defines the number of fields Click Edit schema to make changes to the schema.
Click Sync columns to |
|
Built-in: The schema is created and |
|
Repository: The schema already exists |
Where clauses for (for UPDATE and DELETE |
Enter a clause to filter the data to be updated or deleted |
Default Table Name |
Enter the default table name, between double quotation |
Table name from connection name is variable |
Select this check box when the name of the connection to this component is |
Use different table name |
Select this check box to define a different output table name, |
Mapping |
Specify the metadata mapping file for the database |
Advanced settings
tStatCatcher Statistics |
Select this check box to gather the Job processing metadata at a Job |
Global Variables
Global Variables |
NB_LINE: the number of rows read by an input component or
NB_LINE_INSERTED: the number of rows inserted. This is an
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 |
tELTNetezzaOutput is to be used along Note:
Note that the ELT components do not handle actual data flow but |