tUniservRTPost – Docs for ESB 5.x
tUniservRTPost tUniservRTPost properties Component family Data quality Function tUniservRTPost provides postal validation and correction of addresses, which is critical to improving the quality of addresses. This way, you will be more successful in personalized one-on-one marketing, reducing costs and increasing the efficiency and cost-effectiveness of address management in all the applications. Purpose tUniservRTPost helps…
tTeradataFastLoadUtility – Docs for ESB 5.x
tTeradataFastLoadUtility tTeradataFastLoadUtility Properties Component Family Databases/Teradata Function tTeradataFastLoadUtility reads a database and extracts fields using queries. Purpose tTeradataFastLoadUtility 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…
tTeradataClose – Docs for ESB 5.x
tTeradataClose tTeradataClose properties Component family Databases/Teradata Function tTeradataClose closes the transaction committed in the connected DB. Purpose Close a transaction. Basic settings Component list Select the tTeradataConnection component in the list if more than one connection are planned for the current Job. Advanced settings tStatCatcher Statistics Select this check box to collect log data…
tSybaseSP – Docs for ESB 5.x
tSybaseSP tSybaseSP properties Component family Databases/Sybase Function tSybaseSP calls the database stored procedure. Purpose tSybaseSP offers a convenient way to centralize multiple or complex queries in a database and call them easily. Basic settings Property type Either Built-in or Repository. Since version 5.6, both the Built-In mode and the Repository mode are available in…
tSynonymSearch – Docs for ESB 5.x
tSynonymSearch 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. tSynonymSearch Properties Component family Data Quality Function tSynonymSearch reads input data and searches for reference entries defined in a given synonym index. If this component finds matched…
tTeradataFastExport – Docs for ESB 5.x
tTeradataFastExport tTeradataFastExport Properties Component Family Databases/Teradata Function tTeradataFastExport exports rapidly voluminous data batches from a Teradata table or view. Purpose tTeradataFastExport exports data batches from a Teradata table to a cutsomer system or to a smaller database. Basic settings Use Commandline Select this check box to enable the commandline mode. Use Java API…
tTeradataRow – Docs for ESB 5.x
tTeradataRow tTeradataRow Properties Component family Databases/Teradata Function tTeradataRow 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…
tTeradataTPTExec – Docs for ESB 5.x
tTeradataTPTExec tTeradataTPTExec Properties Component Family Databases/Teradata Function As the combination of tTeradataFastLoad, tTeradataMultiLoad, tTeradataTPump, and tTeradataFastExport, tTeradataTPTExec loads the data from an existing file to a Teradata database. Purpose tTeradataTPTExec offers high performance in inserting data from an existing file to a table in a Teradata database. Basic settings Property Type Either Built-In or…
tSybaseSCDELT – Docs for ESB 5.x
tSybaseSCDELT tSybaseSCDELT Properties Component family Databases/Sybase Function tSybaseSCDELT reflects and tracks changes in a dedicated Sybase SCD table. Purpose tSybaselSCDELT addresses Slowly Changing Dimension needs through SQL queries (server-side processing mode), and logs the changes into a dedicated Sybase SCD table. Basic settings Property type Either Built-in or Repository. Since version 5.6, both the…
tTeradataCommit – Docs for ESB 5.x
tTeradataCommit tTeradataCommit Properties Component family Databases/Teradata Function tTeradataCommit validates the data processed through the Job into the connected DB. Purpose Using a unique connection, this component commits in one go a global transaction instead of doing that on every row or every batch and thus provides gain in performance. Note that if you need…