Talend Corparate Trainning

✅ What is ETL

✅ Market leader tools in ETL domain

✅ Advantages of Talend

✅ History Of TalenD

✅ Talend Open Studio

✅ TOS for Data Integration

✅Launching Talend Studio

✅ Working with different workspace directories

✅ Creating and executing jobs

✅ Connection types and triggers

✅ Using Talend components

✅ Most frequently used Talend components.

✅ Read and Write Various Types of Sources and Target Systems

✅ Working with files [CSV, XLS, XML, Positional]

✅ Working with databases (Oacle DB,Mysql DB )

✅ Metadata management

✅ Context Variables

✅ tMap

✅ tJoin

✅ tFilter

✅ tSortRow

✅ tAggregateRow

✅ tReplicate

✅ tSplit

✅ Lookup

✅ tRowGenerator

✅ Accessing job level/ component level information within the job

✅ SubJob (using tRunJob, tPreJob, tPostJob)

✅ file management (like tFileList, tFileAchive, tFileTouch, tFileDelete)

✅ Error Handling [tWarn, tDie]

✅ Type Casting (convert datatypes among source-target platforms)

✅ Looping components (like tLoop, tForeach)

✅ FTP components (like tFTPFileList, tFTPFileExists, tFTPGet, tFTPPut)

✅ Exporting and Importing Talend jobs

✅ How to schedule and run Talend DI jobs externally (using Command line)

✅ Parameterizing a Talend job from command line

✅ Activate or deactivate a component or SubJob

✅ Importing items

✅ Building Jobs

✅ Exporting items

✅ How to change context parameters in Jobs

✅ Managing Job versions

✅ Generating HTML documentation for a job

✅ Running a Job in normal mode

✅ Running a Job in Java Debug mode

✅ Running a Job in Traces Debug mode

✅ Setting advanced execution settings

✅ showing JVM resource usage during Job execution

✅ What is ELT

✅ Introducing Talend SQL templates

✅ Managing Talend SQL templates

✅ Types of system SQL

✅ templates

✅ How to access a system SQL

✅ template

✅ How to create user-defined

✅ SQL templates

✅ A use case of system SQL templates