Sunday, May 9, 2021

Talend Training Detail

Introduction to Data Warehousing

·         Data Warehouse Overview

·         Facts, Dimensions

·         DW models:- Star and Snowflake schemas.

·   Talend Introduction

·         Introduction to Talend

·         Talend Data Integration 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 scenarios 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 Environment

·         How to integrate talend jobs with java.

*And also provides resume preparation.

*After this training you can handle any Data Integration (ETL) or Migration projects independently.

 

Thanks,

Sharad 

mobile -  +91- 9731059957

Email :-  talendetltraning@gmail.com

 

Tuesday, September 12, 2017

Put File Mask on tFileList Component dynamically in Talend

How I can set file mask for tFilelist component in Talend that it recognize date automatically and it will download only data for desired date?

There are two ways of doing it.
1.    Create context variable and use this variable in file mask.
2.    Directly use TalendDate.getDate() or any other date function in file mask.
See both of them in component
1st Menthod,
·         Create context variable named with dateFilter as string type.
·         Assign value to context.dateFilter=TalendDate.getDate("yyyy-MM-dd");
·         Suppose you have file name as "ABC_2015-06-19.txt" then
·         In tFileList file mask use this variable as follows.
"ABC_"+context.dateFilter+".*"

2nd Menthod
·         In tFileList file mask use date function as follows.
"ABC_"+TalendDate.getDate("yyyy-MM-dd")+".*"


Above are the two best way, you can make changes in file mask per your file names.