tVectorWiseRollback – Docs for ESB 5.x
tVectorWiseRollback tVectorWiseRollback Properties Component family Databases/VectorWise Function tVectorWiseRollback cancels transactions commited to the DB connected. Purpose This component prevents involuntary commits. Basic settings Component list Select the tVectorWiseConnection component from the list if more than one connection is planned for the current job. Close Connection Clear this check box to continue to use…
tTeradataTPump – Docs for ESB 5.x
tTeradataTPump tTeradataTPump Properties Component Family Databases/Teradata Function This component inserts, updates, or deletes data in the Teradata database with the TPump loading utility which allows near-real-time data to be achieved in the data warehouse. Purpose Use this component to insert, update, or delete data in the Teradata Database, particularly for environments where batch windows…
tTeradataRollback – Docs for ESB 5.x
tTeradataRollback tTeradataRollback Properties Component family Databases/Teradata Function tTeradataRollback cancels the transaction commit in the connected DB. Purpose tTeradataRollback avoids to commit part of a transaction involuntarily. Basic settings Component list Select the TeradataConnection component in the list if more than one connection are planned for the current job. Close Connection Clear this check…
tTeradataOutput – Docs for ESB 5.x
tTeradataOutput tTeradataOutput Properties Component family Databases/Teradata Function tTeradataOutput writes, updates, makes changes or suppresses entries in a database. Purpose tTeradataOutput 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…
tUnite – Docs for ESB 5.x
tUnite tUnite Properties Component family Orchestration Function Merges data from various sources, based on a common schema. Warning tUnite cannot exist in a data flow loop. For instance, if a data flow goes through several tMap components to generate two flows, they cannot be fed to tUnite. Purpose Centralize data from various and heterogeneous…
tUniservRTMailOutput – Docs for ESB 5.x
tUniservRTMailOutput tUniservRTMailOutput properties Component family Data Quality Function tUniservRTMailOutput updates the index pool that is used for duplicate search.. Purpose tUniservRTMailOutput keeps the index pool synchronized. Basic settings Schema and Edit schema A schema is a row description. It defines the number of fields to be processed and passed on to the next component….
tVerticaClose – Docs for ESB 5.x
tVerticaClose tVerticaClose properties Component family Databases/Vertica Function tVerticaClose closes the transaction committed in the connected DB. Purpose Close a transaction. Basic settings Component list Select the tVerticaConnection 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…
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…