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+tDB2TemporalDeleteELT

3.1 jlolling 2015-02-25
86

This package contains 2 components:
tDB2TemporalMergeELT
tDB2TemporalDeleteELT

These components supports the ELT usage of the IBM DB2 temporal tables, introduced with the release 10.1 of the IBM DB2 database.

Please refer to the linked documentation!

tDB2TemporalMergeELT create and updates temporal tables.
tDB2TemporalDeleteELT performs temporal deletes.
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).

Component

tMSSqlSCDAdvanced

0.2 gorotman 2015-02-25
38

This component manage a slowly changing dimension table in a data warehouse environment, starting from the source table and its rows changing.

Component

tGzipCompress

1.1 Steven_Crawford 2015-02-23
12

tGzip compress is a very simple component which compresses a file using gzip.

You can choose whether to keep the default file or remove it after the compression is complete.

Component

tOracleTableTransfer

1.9 jlolling 2015-02-21
96

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

tPatternCheck

1.0 smb 2015-02-18
18

Component

tGoogleMapDirections

0.01 valcol 2015-02-18
9

This component uses the latest Google Directions API.
Please take a look at the documentation at https://developers.google.com/maps/documentation/directions/ .

Component

bcLogback

1.0 smb 2015-02-16
7

Component

bcLogbackCatch

1.0 smb 2015-02-16
4

Component

StartTransaction

1 gustavogarcia 2015-02-11
15

Component

QBOAccountInput

1.0 qbo-connect-com 2015-02-10
23

Read Quickbooks Online Accounts.

Version Author Released on Rating Downloads
Regex

Swedish personnummer with accepted foreigners

4.0 mhallam 2014-07-29
71

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
178

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
249

-98.092391

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

Regex

Currency 16,3

4.0 mhallam 2014-07-29
86

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
187

detect random emails

Regex

hour24

4.0 mhallam 2014-07-29
84

from 0 to 23

Regex

daysOfWeek

4.0 mhallam 2014-07-29
86

Saturday ...

Regex

MonthName

4.0 mhallam 2014-07-29
139

January , February ..

Regex

hh:mm

4.0 mhallam 2014-07-29
121

hh:mm

Regex

German postal code match

2.0 fadoe 2014-07-29
189

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.

Product Demo


  • Author: ctoum
  • Categories: Export
  • First revision date: 2011-05-18
  • Latest revision date: 2012-05-31
  • Compatible with: Master Data Management releases 4.2.0, 4.2.0M1, 4.2.1, 4.2.2, 5.0.0, 5.0.0M1, 5.0.0M2
  • Downloads: 719

About: Product & families, with Cafepress pictures.

Revision list

expand/collapse all

Revision 3.0 280 Downloads, Released on 2012-05-31
Download revision 3.0

Compatible with: 5.0.0

The MDM Product Demo project can help you start with Talend Master Data Management.
Discover how to setup and configure the features of Talend Master Data Management via meaningful samples.

Revision 2.0 281 Downloads, Released on 2011-07-29
Download revision 2.0

Compatible with: 5.0.0, 5.0.0M2, 5.0.0M1, 4.2.2, 4.2.1, 4.2.0

New revision for 4.2 compatibility

Revision 1.0 158 Downloads, Released on 2011-05-18
Download revision 1.0

Compatible with: 4.2.0M1

Initial revision.

Reviews (3)

 get starting By zaoweiruan on March 25, 2013
thanks for share learning
 Great start By mbalkenende on August 25, 2011
This is a great start with Data Quilty and MDM processes. Make sure you have the recent patches.

MDM 5.0 By  on March 25, 2013
Hi mbalkenende, Will u please guide me for MDM A to Z. bcoz im new to this field. i dowloaded talend MDM 5.0. Thanks in advance.
 sa By jamikorn on July 20, 2011
excellent
Submit review
Name:*
Email:*
Title:*
Please select your rating*
Review:*



101 ms