Joining two data sources with the tMap component in Talend Studio
In this tutorial, discover how to join two data sources with the tMap component in Talend Studio.
This tutorial makes use of a .csv file. If you do not have
a .csv file, click the
Downloads tab and save movies.csv.
This tutorial also makes use of another
delimited file. If you do not have another delimited file, click
the Downloads tab and save directors.txt.
Creating a Talend Studio project
Creating a project is the first step to using Talend Studio. Projects allow you to better organize your work.
Procedure
Results
Creating a Job to join data sources
Talend Studio projects contain Jobs. In Jobs, you can build workflows through components, which allow you to complete specific actions.
Before you begin
Procedure
Results
Data joining using the tMap component
The tMap component allows you to transform and route data from single or multiple sources to single or multiple destinations.
Creating a metadata definition for the tMap component
Creating a metadata definition allows you to set up reusable information across all of your components.
Before you begin
Procedure
Results
Configuring a tMap component to join two data sources
The tMap component allows you to transform and route data from single or multiple sources to single or multiple destinations. In this case, discover how to join two data sources.
About this task
- Click
the
Downloads tab and save metadata_movies_directors.zip.
- In the Repository, expand Metadata then right-click File delimited and click Import items.
- Select Select archive file: then click Browse to select metadata_movies_directors.zip.
- Select movies 0.1 and directors 0.1.
- Click Finish.
You can also learn how to create both metadata definitions (see Creating a metadata definition for the tMap component).