Talend Training

Talend Training 

+91-720-720-9005 (Whatsapp), www.dwbiadda.com

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

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

1.    Creation and Usage of Context Variables and Context Groups
2.    Dynamic Job designs using Context variables
3.    Making database connectivity parameters as job contexts
4.    Configuring the job to run it on remote machine
5.    Bulk Insert/ Update
6.    How to execute the jobs remotely
7.    Command line utility and basic and advanced commands
8.    How to clean enhance data and reference data
9.    How to migrate jobs from DEV to TESTING to PROD environment
10.    Case study and hands on development training on the required jobs

Metadata  in Talend.

  I.               Built-in Connections

1.    Shared Connections
2.    Source and Destination Connections
3.    Database Connections
4.    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 training talend training in hyderabad  talend online training talend etl tool