tELTNetezzaMap
Uses the tables provided as input, to feed the parameter in the built statement. The
statement can include inner or outer joins to be implemented between tables or between one
table and its aliases.
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.
Helps you to build the SQL statement graphically, using the table provided as
input.
tELTNetezzaMap Standard properties
These properties are used to configure tELTNetezzaMap running in the Standard Job framework.
The Standard
tELTNetezzaMap component belongs to the ELT family.
The component in this framework is available in all Talend
products.
Basic settings
Use an existing connection |
Select this check box and in the Component List click the relevant connection component to Note: When a Job contains the parent Job and the child Job, if you
need to share an existing connection between the two levels, for example, to share the connection created by the parent Job with the child Job, you have to:
For an example about how to share a database connection |
ELT Netezza Map Editor |
The ELT Map editor allows you to define the output schema and make a |
Style link |
Select the way in which links are displayed.
Auto: By default, the links between the
Bezier curve: Links between the schema
Line (fastest): Links between the This option slightly optimizes performance. |
Property type |
Either Built-in or Repository. |
 |
Built-in: No property data stored |
 |
Repository: Select the Repository |
Host |
Database server IP address. |
Port |
Listening port number of DB server. |
Database |
Name of the database. |
Username and Password |
DB user authentication data. To enter the password, click the […] button next to the |
Advanced settings
Additional JDBC parameters |
Specify additional connection properties for the DB connection you are |
tStatCatcher Statistics |
Select this check box to gather the Job processing metadata at a 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 |
tELTNetezzaMap is used along with Note:
Note that the ELT components do not handle actual data flow but |
Dynamic settings |
Click the [+] button to add a row in the table The Dynamic settings table is For examples on using dynamic parameters, see Reading data from databases through context-based dynamic connections and Reading data from different MySQL databases using dynamically loaded connection parameters. For more information on Dynamic |