BISP 

60% Complete Courses » Talend Administration
  • Course Content
  • Course Overview
  • Training Schedule
  • Demo Video
  • Learning Material
  • Register


Module 1: Data integration (ETL) with Talend Open Studio
Module 2: Talend Administration Center (TAC)

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

Data Warehousing Introduction
❖ Overview of the concept of Data Warehouse.
❖ Dimensions, Hierarchy, Facts
❖ DW models:- Star and Snowflake schemas.
❖ Introduction to Talend
❖ Talend Data Integration Overview

Talend Introduction
❖ Talend Environment – Overview
❖ Talend installation
❖ Starting Talend job design and development
❖ Repository, Designer and Palette
❖ Talend Design

Talend Jobs Designing
❖ Types of Components
❖ Basic Components - Overview
❖ Component Properties
❖ Database connectivity components
❖ Triggers in Talend
❖ Sample Job designing
❖ Job Execution
❖ Usage of tMap component and other important components from all sections like
Processing, Orchestration, File, database etc.
❖ Exercises for job development (hands on training)
❖ How to Capture information about job execution
❖ How to create a table to store monitoring information
❖ Detailed Log Generation:
❖ Number of records inserted/ updated/ rejected. In case of failure,details of the
failed records.
❖ Exercises for job development (hands on training)
❖ Optimization for running the job

Talend Context and Variables
❖ Context Variables - Overview
❖ Creation and Usage of Context Variables and Context Groups
❖ Dynamic Job designs using Context variables
❖ Making database connectivity parameters as job contexts
❖ Configuring the job to run it on remote machine
❖ Bulk Insert/ Update
❖ How to execute the jobs remotely
❖ Command line utility and basic and advanced commands
❖ How to clean enhance data and reference data
❖ How to migrate jobs from DEV to TESTING to PROD environment
❖ Case study and hands on development training on the required jobs

Metadata in Talend.
❖ Built-in Connections
❖ Shared Connections
❖ Source and Destination Connections
❖ Database Connections
❖ Usage of connections in Job

Logs & Error
❖ Logs and execution statistics in Talend
❖ Error Handling in Talend
❖ Logs & Error Handling Components
❖ In case of notification failure Email generation
❖ Optimization for running the job

Exercises
❖ Real time schenaios on all discussed components
❖ Optimization for running the job
❖ How to migrate jobs from DEV to TESTING to PROD environment
❖ Case study and hands on development training on the required jobs
❖ How to run jobs in Linux Enviromnet
❖ How to integrate talend jobs with java.

Module 2: Talend Administration Center (TAC)

Talend Administration Center : Concepts and Principles
❖ Operating principles
❖ Explain About TAC Architecture
❖ Modules and features per license
❖ User roles/rights in Administration Center
❖ User and project types

Getting started with Talend Administration Center
❖ Prerequisites
❖ Accessing the Administration Center
❖ Configure Talend Administration Center
❖ Managing users, Projects and Licenses
❖ Managing rights associated with roles
❖ Managing notifications
❖ Checking for updates
❖ Changing user passwords

Installation and Configuration of SVN and GIT Repository

Backing up databases and SVN repositories
❖ Prerequisites
❖ Scheduling backup
❖ Executing a backup

Executing Jobs, Routes and Services
❖ Configuration execution Servers
❖ Configuring virtual servers
❖ Planning the execution of data integration jobs
❖ Executing Big Data Streaming Jobs from Big data Streaming conductor
❖ Publishing Services, Routes, and Jobs
❖ Working in cluster mode
❖ Monitoring task execution and accessing logs
Course Id:
Tld002 
Course Fees:
301 USD