Getting started with talend studio

Author : Vivek Vardhan Varanasi

Lets assume we have 4 files

1. File 1 – having id and firstname
2. File 2 – having id and age
3. File 3 – having id and salary
4. File 4 – having id and address

You a scenario where you need find a list people whose age is greater than 20 and salary is greater than 10,000$ in a particular location.

How do you achieve it in Talend. There are multiple ways in doing, lets see one of a simple way.

Step 1 : Merge all the 4 files and make one single file

Step 2 : Send the following output to a database and write a query

Talend components used

1. tFileDelimitedInput
2. tMap
3. tLogRow
4. tMSSQLOutput

Overall design of Talend Job :

Input files with sample data

first use tFileInputDelimited component to read the file and provide schema ( each file will have different schema )

Use tmap to unite and lookup between the files to map id’s with relevant fields.