tTeradataTPTUtility – Docs for ESB 5.x
tTeradataTPTUtility tTeradataTPTUtility Properties Component Family Databases/Teradata Function As the combination of tTeradataFastLoad, tTeradataMultiLoad, tTeradataTPump, and tTeradataFastExport, tTeradataTPTUtility writes the incoming data to a file and then loads the data from the file to a Teradata database. Purpose tTeradataTPTUtility writes the incoming data to a file and then loads the data from the file to…
tTeradataInput – Docs for ESB 5.x
tTeradataInput tTeradataInput Properties Component family Databases/Teradata Function tTeradataInput reads a database and extracts fields based on a query. Purpose tTeradataInput 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…
tTeradataMultiLoad – Docs for ESB 5.x
tTeradataMultiLoad tTeradataMultiLoad Properties Component Family Databases/Teradata Function tTeradataMultiLoad reads a database and extracts fields using queries. Purpose tTeradataMultiLoad 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…
tVectorWiseCommit – Docs for ESB 5.x
tVectorWiseCommit tVectorWiseCommit Properties Component family Databases/VectorWise Function tVectorWiseCommit validates the data processed in a Job into the connected DB. Purpose Using a single connection, this component commits a global transaction in one go instead of doing so on every row or every batch. This provides a gain in performance Note that if you need…
tSybaseSCD – Docs for ESB 5.x
tSybaseSCD tSybaseSCD properties Component family Databases/Sybase Function tSybaseSCD reflects and tracks changes in a dedicated Sybase SCD table. Purpose tSybaseSCD 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…
tUniservRTMailSearch – Docs for ESB 5.x
tUniservRTMailSearch tUniservRTMailSearch properties Component family Data quality Function tUniservRTMailSearch searches for similar data based on the given input record. Purpose tUniservRTMailSearch searches for duplicate values and adds additional data to each record. Basic settings Schema and Edit schema A schema is a row description. It defines the number of fields to be processed and…
tUniservBTGeneric – Docs for ESB 5.x
tUniservBTGeneric tUniservBTGeneric properties Component family Data quality Function tUniservBTGeneric enables the execution of a processing created with the Uniserv product DQ Batch Suite. Purpose tUniservBTGeneric sends the data to the DQ Batch Suite and starts the specified DQ Batch Suite job. When the job execution is finished, the results are returned to the Data…
tUniqRow – Docs for ESB 5.x
tUniqRow tUniqRow Properties Component family Data Quality Function Compares entries and sorts out duplicate entries from the input flow. Purpose Ensures data quality of input or output flow in a Job. Basic settings Schema and Edit schema A schema is a row description, it defines the number of fields to be processed and passed…
tVectorWiseRow – Docs for ESB 5.x
tVectorWiseRow tVectorWiseRow Properties Component family Databases/VectorWise Function tVectorWiseRow is the specific component for this database query. It executes the SQL query stated in 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…
tUniservRTConvertName – Docs for ESB 5.x
tUniservRTConvertName tUniservRTConvertName properties Component family Data quality Function tUniservRTConvertName analyzes the name line against the context. For individual persons, it divides the name line into segments (name, first name, title, name prefixes, name suffixes, etc.) and creates the address key. The component recognizes company or institution addresses and is able to provide the form…