tPigAggregate – Docs for ESB 5.x
tPigAggregate Warning This component will be available in the Palette of the studio on the condition that you have subscribed to one of the Talend solutions with Big Data. tPigAggregate Properties Component family Big Data / Hadoop Function This component allows you to group the original data by column and add one or more…
tPostgresqlInput – Docs for ESB 5.x
tPostgresqlInput tPostgresqlInput properties Component family Databases/ PostgreSQL Function tPostgresqlInput reads a database and extracts fields based on a query. Purpose tPostgresqlInput 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…
tPostgresqlOutputBulk – Docs for ESB 5.x
tPostgresqlOutputBulk tPostgresqlOutputBulk properties The tPostgresqlOutputBulk and tPostgresqlBulkExec components are generally used together as part of a two step process. In the first step, an output file is generated. In the second step, this file is used in the INSERT operation used to feed a database. These two steps are fused together in the tPostgresqlOutputBulkExec component,…
tPostgresqlRow – Docs for ESB 5.x
tPostgresqlRow tPostgresqlRow properties Component family Databases/Postgresql Function tPostgresqlRow is the specific component for the 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…
tPrejob – Docs for ESB 5.x
tPrejob tPrejob properties Component family Orchestration Function tPrejob starts the execution of a prejob. Purpose tPrejob triggers a task required for the execution of a Job Global Variables ERROR_MESSAGE: the error message generated by the component when an error occurs. This is an After variable and it returns a string. This variable functions only…
tQASBatchAddressRow – Docs for ESB 5.x
tQASBatchAddressRow 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. The address management components discussed here are the result of Talend collaboration with Experian QAS, one of the world leaders for global address data quality. For more information…
tRedshiftCommit – Docs for ESB 5.x
tRedshiftCommit tRedshiftCommit properties Component family Databases/Amazon Redshift Function tRedshiftCommit validates the data processed through the Job into the connected database. 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…
tPostgresqlOutputBulkExec – Docs for ESB 5.x
tPostgresqlOutputBulkExec tPostgresqlOutputBulkExec properties The tPostgresqlOutputBulk and tPostgresqlBulkExec components are generally used together as part of a two step process. In the first step, an output file is generated. In the second step, this file is used in the INSERT operation used to feed a database. These two steps are fused together in the tPostgresqlOutputBulkExec component….
tRedshiftInput – Docs for ESB 5.x
tRedshiftInput tRedshiftInput properties Component family Databases/Amazon Redshift Function tRedshiftInput 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 through a Main row link. Purpose tRedshiftInput reads data from a database and extracts fields based on a…
tRedshiftRollback – Docs for ESB 5.x
tRedshiftRollback tRedshiftRollback properties Component family Databases/Amazon Redshift Function tRedshiftRollback cancels the transaction commit in the connected DB. Purpose This component is used to avoid committing part of a transaction involuntarily. Basic settings Component list Select the tRedshiftConnection component in the list if more than one connection are planned for the current job. Close…