tTeradataFastLoad – Docs for ESB 5.x
tTeradataFastLoad tTeradataFastLoad Properties Component Family Databases/Teradata Function tTeradataFastLoad reads a database and extracts fields using queries. Purpose tTeradataFastLoad executes a database query according to a strict order which must be the same as the one in the schema. The retrieve list of fields is then transfered to the next component, using a connection flow…
tTeradataConnection – Docs for ESB 5.x
tTeradataConnection tTeradataConnection Properties Component family Databases/Teradata Function tTeradataConnection opens a connection to the database for a current transaction. Purpose This component is used to open a connection to the specified database that can then be reused in the subsequent subjob or subjobs. Basic settings Property type Either Built-in or Repository. Since version 5.6, both…
tSystem – Docs for ESB 5.x
tSystem tSystem Properties Component family System Function tSystem executes one or more system commands. Purpose tSystem can call other processing commands, already up and running in a larger Job. Basic settings Use home directory Select this check box to change the name and path of a dedicated directory. Use Single Command When the…
tVectorWiseConnection – Docs for ESB 5.x
tVectorWiseConnection tVectorWiseConnection Properties Component family Databases/VectorWise Function tVectorWiseConnection opens a connection to a database for a transaction to be carried out. Purpose This component is used to open a connection to the specified database that can then be reused in the subsequent subjob or subjobs. Basic settings Property type Either Built-in or Repository. Since…
tVerifyEmail – Docs for ESB 5.x
tVerifyEmail Warning This component will be available in the Palette of Talend Studio on the condition that you have subscribed to one of the Talend Platform products. tVerifyEmail properties Component family Data Quality Function tVerifyEmail verifies and formats email addresses against patterns and regular expression. Purpose tVerifyEmail enables you to verify if email addresses…
tSybaseRow – Docs for ESB 5.x
tSybaseRow tSybaseRow Properties Component family Databases/Sybase Function tSybaseRow is the specific component for this database query. It executes the SQL query stated onto the specified database. The row suffix means the component implements a flow in the job design although it doesn’t provide output. Purpose Depending on the nature of the query and the…
tVerticaSCD – Docs for ESB 5.x
tVerticaSCD tVerticaSCD Properties Component family Databases/Vertica Function tVerticaSCD reflects and tracks changes in a dedicated Vertica SCD table. Purpose tVerticaSCD addresses Slowly Changing Dimension needs, reading regularly a source of data and logging the changes into a dedicated SCD table Basic settings Property type Either Built-in or Repository. Since version 5.6, both the Built-In…
tVerticaOutput – Docs for ESB 5.x
tVerticaOutput tVerticaOutput Properties Component family Databases/Vertica Function tVerticaOutput writes, updates, makes changes or suppresses entries in a database. Purpose tVerticaOutput executes the action defined on the table and/or on the data contained in the table, based on the flow incoming from the preceding component in the job. Basic settings Property type Either Built-in or…
tVerticaInput – Docs for ESB 5.x
tVerticaInput tVerticaInput Properties Component family Databases/Vertica Function tVerticaInput reads a database and extracts fields based on a query. Purpose tVerticaInput executes a DB query with a strictly defined order which must correspond to the schema definition. Then it passes on the field list to the next component via a Main row link. Basic settings…
tXSDValidator – Docs for ESB 5.x
tXSDValidator tXSDValidator Properties Component family XML Function Validates an input XML file or an input XML flow against an XSD file and sends the validation log to the defined output. Purpose Helps at controlling data and structure quality of the file or flow to be processed Basic settings Mode From this dropdown list, select:…