tBufferCopyInput

With original Talend tBufferInput component, it is not possible to make in the same subjob a chain "tBufferInput > ... > tBufferOutput", since these two components use the same globalBuffer list.

This tBufferCopyInput makes a copy of the globalBuffer list, and reads data rows from this copy. After that, the tBufferOutput can write data rows in the global buffer without memory exception.

So a chain "tBufferCopyInput > ... > tBufferOutput" works fine.

After making a copy of the global buffer, it is possible to clear it, in order to allow the tBufferOutput component to write data rows in an empty buffer.

tRunJob2

This component is a variation of the tRunJob component.

In the original tRunJob component, you can get the child job output (with a tBufferOutput component in the child job), but you can't send data rows to the child job.

As the original tRunJob component, context parameters can be sent to the child job.

This tRunJob2 component does the contrary : you can send data rows to the child job (with a tBufferOutput in the parent job, and a tBufferInput in the child job), but you can't get data from the child job.

User manual :
1) In the parent job, send data rows to a tOutputBuffer component : They will be automatically copied in the globalBuffer of the child job
2) In the child job, use a tInputBuffer to get theses data rows

See the screenshot for an example.

DEPRECATED COMPONENT : consider using the tRunJobRow component instead.

tBufferOutput

Output buffer

Evolution of Talend's original tBufferOutput component in order to add a "empty global buffer" checkbox.

If checked, the buffer will be cleared before adding data rows. So, several couples "tOutputBuffer/tInputBuffer" can be used in the same job.

Warning : DO NOT use chains "tInputBuffer => ... => tOutputBuffer" in your jobs. There will be a MemoryException. You can do that chain with the tBufferCopyInput component.

Warning : the "clean option" of this component is executed in the begin jet template. So, chronologicaly, it will be the first thing done in the subjob.
So, in a chain "tBufferCopyInput => ... => tOutputBuffer", to get a clean output buffer before writing data, you MUST use the tBufferCopyInput clean option.

tInformixSP

Informix stored procedure

This component allows to use Informix stored procedures and functions.

Not existing in origanal Informix components.

Can be used with an existing tInformixConnection.

This component has been improved and added to TOS 4.0.0+. So it is now supported on Talend bugtracker.

tInformixRow

Informix Database SQL row

Evolution of Talend's original tInformixRow component in order to use Informix in transactionnal mode with the tInformixConnection, tInformixCommit and tInformixRollback components.

This component has been added to TOS 4.0.0+. So it is now supported on Talend bugtracker.

tInformixOutput

Informix Database SQL output

Evolution of Talend's original tInformixOutput component in order to use Informix in transactionnal mode with the tInformixConnection, tInformixCommit and tInformixRollback components.

Warning : this component is built using a skeleton in main JET template, whose path is relative. So, it MUST be placed in the "plugins/org.talend.designer.components.localprovider_VERSION/components" folder. If not, the component template won't compile !

This component has been improved and added to TOS 4.0.0+. So it is now supported on Talend bugtracker.

tInformixInput

Informix Database SQL input

Evolution of Talend's original tInformixInput component in order to use Informix in transactionnal mode with the tInformixConnection, tInformixCommit and tInformixRollback components.

This component has been improved and added to TOS 4.0.0+. So it is now supported on Talend bugtracker.

tInformixRollback

Informix rollback

Not existing in original Informix components.

Must use with an existing tInformixConnection.

This component has been added to TOS 4.0.0+. So it is now supported on Talend bugtracker.

tInformixCommit

Informix commit

Not existing in origanal Informix components.
Must use with an existing tInformixConnection.

This component has been added to TOS 4.0.0+. So it is now supported on Talend bugtracker.

tInformixConnection

Informix Database SQL connexion

Implement Informix transaction in Talend Job.

Not existing in origanal Informix components.

Can be used with tInformixInput, tInformixOutput, tInformixRow, tInformixCommit, tInformixRollBack.

This component has been added to TOS 4.0.0+. So it is now supported on Talend bugtracker.

Frequency table of hours

This indicator helps to analyze the most frequent day hours that appear in date time columns.

Sample Standard Deviation

This indicator computes the sample standard deviation of any numerical column

Variance

This indicator computes the variance of numeric columns

Trimmed

evaluate the number of data which are correctly trimmed

Week Frequency

aggregates Date fields into weeks

Duplicate Rows

this indicator counts the number of duplicate rows.
It's different from the system indicator called "duplicate count" because it counts the number of duplicate rows, not the number of duplicate values.

Length Range Frequency

get length ranges of data.

group data according to their length range.
Ranges are the following:
data of length < 10
data of length < 20
data of length < 30
data of length >= 30
null data

Order of Magnitude

measure the order of magnitude of numerical data

phone_area_code_freq

Area codes of American phone numbers

udi_average_yearly_income

parses $50K - $70K and return the average value

Product Demo

Product & families, with Cafepress pictures.

Clinical Trials: Janus Model Basics

This is a model of the basic of the Janus Clinical Data Repository.
http://www.fda.gov/ForIndustry/DataStandards/StudyDataStandards/ucm155327.htm

D* Demo Model

Model used in the D* Demo.

Talendshop Demo

Talendshop Demo (Demo Project)