Talend

Talend training

Available Trainings

11th Apr, 2018 -  9th Aug, 2018     07:00  -  09:00     30 Hours
Online 
18000
Take Traning

Course Syllabus

Talend Training

Module 1: Data integration (ETL) with Talend Open Studio

Data Warehousing Introduction

1. Overview of the concept of Data Warehouse.

2. Dimensions, Hierarchy, Facts

3. DW models:- Star and Snowflake schemas.

4. Introduction to Talend

5. Talend Data Integration Overview

Talend Introduction

1. Talend Environment ΓΆβ?¬β?? Overview

2. Talend installation

3. Starting Talend job design and development

4. Repository, Designer and Palette

5. Talend Design

5.

Talend Jobs Designing

1.Types of Components

2. Basic Components - Overview

3. Component Properties

4. Database connectivity components

5. Triggers in Talend

6. Sample Job designing

7. Job Execution

8. Usage of tMap component and other important components from all sections like Processing, Orchestration, File, database etc.

9. Exercises for job development (hands on training)

10. How to Capture information about job execution

11. How to create a table to store monitoring information

12. Detailed Log Generation:

13. Number of records inserted/ updated/ rejected. In case of failure,details of the failed records.

14. Exercises for job development (hands on training)

15. Optimization for running the job

Talend Context and Variables

I. Context Variables - Overview

II. Creation and Usage of Context Variables and Context Groups

III. Dynamic Job designs using Context variables

IV. Making database connectivity parameters as job contexts

V. Configuring the job to run it on remote machine

VI. Bulk Insert/ Update

VII. How to execute the jobs remotely

VIII. Command line utility and basic and advanced commands

IX. How to clean enhance data and reference data

X. How to migrate jobs from DEV to TESTING to PROD environment

XI. Case study and hands on development training on the required jobs

Metadata in Talend.

I. Built-in Connections

II. Shared Connections

III. Source and Destination Connections

IV. Database Connections

V. Usage of connections in Job

Logs & Error

a) Logs and execution statistics in Talend

b) Error Handling in Talend

c) Logs & Error Handling Components

d) In case of notification failure Email generation

e) Optimization for running the job

Exercises

1. Real time schenaios on all discussed components

2. Optimization for running the job

3. How to migrate jobs from DEV to TESTING to PROD environment

4. Case study and hands on development training on the required jobs

5. How to run jobs in Linux Enviromnet

6. How to integrate talend jobs with java.

Talend training courses talend open studio trainingtalend training in hyderabad talend online trainingtalend etl tool