Talend

What you will learn

Start Talend Open Studio for Data Integration

Create a Talend project to contain tasks

Create a Talend Job to perform a specific task

Add and configure components to handle data input, data transformation, and data output

Run a Talend Job and examine the results

Extend data from one source with data extracted from a second source

Log data rows in the console rather than storing them

Execute Job sections conditionally

Duplicate output flows

Create variables for component configuration parameters

Connect to a database from a Talend Job

Use a component to create a database table

Write to and read from a database table from a Talend Job

Filter unique data rows

Perform aggregate calculations on rows

Export a Job

Run an exported Job independently of Talend Open Studio

Create a new version of an existing Job

Course Outline

Starting Talend Open Studio

Creating a Job

Reading Input

Transforming Data

Running a Job

Combining Columns

Building a Business Model

Duplicating a Job

Creating Metadata

Creating a Join

Capturing Join Failures

Correcting the Lookup

Updating the Business Model

Generating Rows

Creating the Join

Adding Constraints

Replicating Output

Using Context Variables

Using Repository Context Variables

Handling Errors

Working with Databases

Creating a New Project

Creating Customer Metadata

Creating the Customer Table

Creating the Product Table

Setting up Sales Files

Setting Up the Shop Staging Table

Joining the Data

Finalizing the Job

Documenting the Job

Running Jobs Standalone

Exporting a Job