Talend Exchange is the place where Talend community can share items related to Talend opensource products, such as Data Integration, Data Quality and Data Master Management. Contribution is open to any user, no specific validation is needed. As soon as you have your forum account, you automatically get a Talend Exchange account.


Version Author Released on Rating Downloads
Component

tDB2TemporalMergeELT

1.8 jlolling 2014-07-01
8

This component is an ELT usage of the DB2 temporal tables, introduced with the release 10.1 of the IBM DB2 database.
Temporal tables are a native Slowly Changing Dimension Type 2 implementation (with bi-temporal means you have a business time period and a system time period for the validity of your data).
This component create and run all necessary statement to:
create tables (actual data and history data)
create indices
merge or the date from the source table (insert, update and delete)
managing the versioning

Component

tFileInputTextFlat

3.2 jlolling 2014-06-30
23

This component is dedicated to read text files.
Advantages:
* reads fields with gaps between them
* can configure the columns by the header line (also with regex)
* reduced byte code foodprint
* can apply regex expressions to the field content
* translates the numbers for any country formats

Component

tLOBDownload

1.0 jlolling 2014-06-30
11

This component downloads a LOB (BLOB or CLOB) object.
For CLOB content you can set a charset because the CLOBs like BLOBs are always byte streams.

Component

tFileExcelSheetList

6.3 jlolling 2014-06-30
42

This component iterates through the sheets of a excel workbook.
It depends on the component tFileExcelWorkbookOpen.
The sheets can be retrieved within an iteration as well as in a flow.

Component

tJsonNormalize

1.3 jlolling 2014-06-29
31

It normalizes JSON objects (received as text column or from a MongoDB).
The component goes recursive through the JSON object and returns all simple values (also in arrays) with the value, and the path the the attribute.

Component

tNormalizeSchema

1.0 jlolling 2014-06-29
14

This component normalises denormalized schemas.
If you have repeated column groups and you need to have them only once but as rows.
You can actually do the same with tSplitRow but in tSplitRow you have to configure every assignment by hand which leads for a large number of columns and large number or repetitions to a nightmare and error prone task.
Please take a look at the documentation.

Component

tFTPClose

1.1 jlolling 2014-06-29
14

Closes a FTP connection (also SFTP the other supported connection types).
This is necessary to use FTP connections in embedded jobs which will be called multiple times. Unfortunately normal FTP connections will not be closed and this can lead to connection errors.

Component

tSQLScriptParser

1.2 jlolling 2014-06-29
19

This component can iterate through SQL statements in a script read from the SQL input in the component or from a file.
It detects the OraclePlus delimiter / to separate complex statements like begin-end or create or replace procedure etc.

Component

tRunTask

1.7 jlolling 2014-06-29
25

This component can trigger task in the Talend Administration Center.
It helps to create sophisticated job chains because you can detect in the unlimited flexibility the necessary events or parameters to start a task in the TAC.
With the help of this component you can avoid deploying \"monster\" jobs containing all jobs needed in a complex task. You simply deploy all necessary jobs as tasks and starts them with a another job.
You can stop the \"trigger\" job and all currently running task will finishes they work without being interrupted.

Component

tJasperServerFileDelete

2.0 jlolling 2014-06-29
10

This component can delete resources on a JasperServer.

test parser rule


  • Author: scorreia
  • Categories: ParserRule
  • First revision date: 2011-09-01
  • Latest revision date: 2011-09-01
  • Compatible with: Data Quality releases 5.0.0, 5.0.0M3, 5.0.0M4, 5.0.0M5, 5.0.0RC1, 5.0.0RC2, 5.0.0RC3, 5.2.0M2
  • Downloads: 129

About: this is a test only

Revision list

expand/collapse all

Revision 0.1 129 Downloads, Released on 2011-09-01
Download revision 0.1

Compatible with: 5.2.0M2, 5.0.0, 5.0.0RC3, 5.0.0RC2, 5.0.0RC1, 5.0.0M5, 5.0.0M4, 5.0.0M3

this is for test only

Reviews (0)

Be the first to review this extension!

 

Submit review
Name:*
Email:*
Title:*
Please select your rating*
Review:*


Version Author Released on Rating Downloads
Export

DStar

1.0 ctoum 2010-08-04
1126

D* Industries Demo Model


97 ms