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

tCalendar

1.2 jlolling 2014-09-17
55

Data warehouses needs a date dimension and this component creates the most of the needed data (also fully localised).
The schema of this component is fully commented.
The main features are:
* creates all possible date categories like day, week, month, year, quarter
* builds integer id for all categories to support a table as dimension
* supports different years (year for the current week and a financial year)
* build automatically a configurable amount of days in the future.

Component

tRunTask

1.8 jlolling 2014-09-12
46

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

tJobInstance* component collection

3.3 jlolling 2014-09-12
50

These 4 components:
- tJobInstanceStart
- tJobInstanceEnd
- tJobDataRangeScanner
- tJobInstanceLiveCheck
are dedicated to manage job monitoring.
These components provides following features:
* Creates an job instance Id to mark the datasets for data lineage
* holds all necessary information about a job run in a table
* keeps all context variables in a table (at the job start and its end)
* keeps as much as needed counters from the job
* provides incremental loads
* provides a lot of key figures about the last job run
* keeps the error messages from the job in the status table
* enables Log4J for the job with various outputs
* Provides maximum memory usage tracking

Please refer the linked documentation
The release 3.0 needs slightly changed tables!
Please contact me in case of questions and do not use the rating function to post questions.

Component

tTableauTriggerSchedule

1.0 tfoldi 2014-09-11
3

This component can trigger Tableau Server\'s schedule directly from any platform. It does not depend on tabcmd and written in pure java.

Component

tDB2TemporalMergeELT

2.1 jlolling 2014-09-09
12

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

tUniservCDHInput

2.4.0 dqsh_uniserv 2014-09-04
6

todo description

Component

tGoogle

1.0 Lesego 2014-08-28
0

Component

tPostgresqlTableTransfer

1.8 jlolling 2014-08-27
7

This component is dedicated to transfer the table content from one database to another database.
The component can truncate the target table before.
This component does not care about schema differences. All columns existing in source and target table will be transferred, all other ignored. The necessary schema will be created internally, therefore you have to provide only the source and target table name, thats it.
The component uses asynchronous transfer to half the duration because reading and writing can take place at the same time (or overlapping).

Component

tOracleTableTransfer

1.8 jlolling 2014-08-27
20

This component is dedicated to transfer the table content from one database to another database.
The component can truncate the target table before.
This component does not care about schema differences. All columns existing in source and target table will be transferred, all other ignored. The necessary schema will be created internally, therefore you have to provide only the source and target table name, thats it.
The component uses asynchronous transfer to (up to) halve the duration because reading and writing can take place at the same time (or overlapping).

Component

tDB2TableTransfer

1.8 jlolling 2014-08-27
4

This component is dedicated to transfer the table content from one database to another database.
The component can truncate the target table before.
This component does not care about schema differences. All columns existing in source and target table will be transferred, all other ignored. The necessary schema will be created internally, therefore you have to provide only the source and target table name, thats it.
The component uses asynchronous transfer to half the duration because reading and writing can take place at the same time (or overlapping).

Version Author Released on Rating Downloads
Regex

Swedish personnummer with accepted foreigners

4.0 mhallam 2014-07-29
46

Other Swedish personnummer regexps do not take into account that at Swedish universities, foreigners might get special temporary personnummers with a "P", "T", or "F" instead of the first of the four last numbers.

This code fixes the problem, but does not check the validity of the date, or the last number.

Regex

Istat Code

4.0 mhallam 2014-07-29
147

22.12.0|18.24.C||22.12_D|12.56| 1A.56.1

This pattern match the Italian Istat Ateco Code (Codice Istat) updated to Istat Declaration Ateco 2004

Regex

Longitude Validation

4.0 mhallam 2014-07-29
219

-98.092391

Longitude validation (similiar to Latitude Validation) and inspired by the same code

Regex

Currency 16,3

4.0 mhallam 2014-07-29
58

Currency expression, accepts 4 commas and 4 groups of 3 numbers and 1 number before the first comma, this first number will have to be different from zero. It accepts a number of, two or three decimal. It accepts zero numbers after the point. You can change the number of groups and numbers accespts before and after the point.

Regex

Random email

2.0 scorreia 2014-07-29
154

detect random emails

Regex

hour24

4.0 mhallam 2014-07-29
60

from 0 to 23

Regex

daysOfWeek

4.0 mhallam 2014-07-29
66

Saturday ...

Regex

MonthName

4.0 mhallam 2014-07-29
115

January , February ..

Regex

hh:mm

4.0 mhallam 2014-07-29
96

hh:mm

Regex

German postal code match

2.0 fadoe 2014-07-29
162

This regular expression not only checks if the postal code is five digits long. The second digit must not be zero, because a postal code like 00123 is invalid.

D* Demo Model


  • Author: ctoum
  • Categories: Data-Model
  • First revision date: 2010-08-13
  • Latest revision date: 2010-08-13
  • Compatible with: Master Data Management releases 4.0.2, 4.0.3
  • Downloads: 748

About: Model used in the D* Demo.

Revision list

expand/collapse all

Revision 1.0 748 Downloads, Released on 2010-08-13
Download revision 1.0

Compatible with: 4.0.3, 4.0.2

DStar model

Reviews (1)

 Review By Bernardo Silva on March 25, 2013
Review
Submit review
Name:*
Email:*
Title:*
Please select your rating*
Review:*



98 ms