Talend Training
Talend
Learn how to extract data with Talend
French / English
Certificate
Overview
Talend Open Studio (TOS) is an open source ETL application that enables massive synchronization of information from one database to another. This course will teach you how to design, model and develop TOS jobs in order to deal with the following issues.
Prerequisites
Have a knowledge of the SQL language
Goals
Design and develop jobs in the Talend ETL application
Optimising the jobs developed by using contexts and data sets
Perform more complex transformations using variables, expressions and joins
Run and debug a job, trace execution statistics
Training Program
PRESENTATION
- Data integration. ETL solutions
- TOS: installation, user preferences. Reference documentation
- Product philosophy. Job design
- TOS: installation, user preferences. Reference documentation
- Product philosophy. Job design
MODEL THE NEED, DESIGN A FIRST JOB
- Business Modeler. Job Designer
- Main connections. CSV and XML components
- Simple transformation components
- View generated code, run a job
- Main connections. CSV and XML components
- Simple transformation components
- View generated code, run a job
OPTIMISATION THE DEVELOPMENT OF JOBS
- Set up reusable connections using metadata
- Update metadata and propagate it to jobs, import/export metadata
- Setting up jobs by contexts
- Externalise context variables into ".properties" and ".ini" files
- Create and manage your own variables
- Generate data sets for testing
- Update metadata and propagate it to jobs, import/export metadata
- Setting up jobs by contexts
- Externalise context variables into ".properties" and ".ini" files
- Create and manage your own variables
- Generate data sets for testing
WORKING WITH DATABASES
- Supported databases and main components
- Table operation settings
- Metadata and connection context to a database schema
- Connection sharing and transaction management
- Create queries using SQLBuilder
- Table operation settings
- Metadata and connection context to a database schema
- Connection sharing and transaction management
- Create queries using SQLBuilder
WORKING WITH MULTI-SOURCE DATA
- Presentation of the tMap component
- Configuration of input streams, creation of joins
- Perform transformations using variables, expressions and joins
- Qualify the data using filters
- Generate multiple outputs, manage rejections
- Configuration of input streams, creation of joins
- Perform transformations using variables, expressions and joins
- Qualify the data using filters
- Generate multiple outputs, manage rejections
Project
01.
Final project to be carried out :
Extract and transform data with TOS for a survey based on a census of young
entrepreneurs in a city of your choice in Cameroon and specify the field in which they
are undertaking.
