Talend Open studio course by mahesh (Mahesh is Not Talend company employee and this course is not from Talend company)

Exporting Metadata as context 

1. Chapter 1

•  Data integration and Talend Studio 

•    Data analytics 

•  Operational integration 

•  Execution monitoring 2

  Chapter 2

•  Getting started with Talend Studio 

•   Important concepts in Talend Open Studio for Data Integration 

•  Launching Talend Open Studio for Data Integration 

•  How to launch the Studio for the first time 

•  How to set up a project 

•  Working with different workspace directories 

•  How to create a new workspace directory 

•  Working with projects 

•  How to create a project 

•  How to import the demo project 

•  How to import projects 

•  How to open a project 

•  How to delete a project 

•  How to export a project 

•  Migration tasks 

•  Setting Talend Open Studio for Data Integration preferences 

•  Java Interpreter path

•  External or User components 

•  Exchange preferences 

•  Language preferences 

•  Debug and Job execution preferences 

•  Designer preferences

•  Adding code by default 

•  Performance preferences 

•  Documentation preferences 

•  Displaying special characters for schema columns 

•  SQL Builder preferences 

•  Schema preferences

•  Libraries preferences 

•  Type conversion 

•  Usage Data Collector preferences 

•  Customizing project settings 

•  Palette Settings 

•  Version management

•  Status management

•  Job Settings 

•  Stats & Logs 

•  Context settings 

•  Project Settings use 

•  Status settings 

•  Security settings 

Chapter 3 

•  Designing a data integration Job 

•  What is a Job design

•  Getting started with a basic Job design 

•  How to create a Job

•  How to drop components to the workspace 

•  How to search components in the Palette 

•  How to connect components together 

•  How to drop components in the middle of a Row link 

•  How to define component properties 

•  How to run a Job 

•  How to customize your workspace 

•  Using connections 

•  Connection types 

•  How to define connection settings 

•  Using the Metadata Manager 

•  How to centralize the Metadata items 

•  How to centralize contexts and variables 

•  How to use the SQL Templates 

•  Handling Jobs: advanced subjects 

•  How to map data flows 

•  How to create queries using the SQLBuilder 

•  How to download/ upload Talend Community components 

•  How to install external modules 

•  How to launch a Job periodically 

•  How to use the tPrejob and tPostjob components 

•  How to use the Use Output Stream feature 

•  Handling Jobs: miscellaneous subjects 

•  How to share a database connection 

•  How to define the Start component 

•  How to handle error icons on components or Jobs 

•  How to add notes to a Job design 

•  How to display the code or the outline of your Job 

•  How to manage the subjob display 

•  How to define options on the Job view 

•  How to find components in Jobs 

•  How to set default values in the schema of an component 

Chapter 4  

•  Managing data integration Jobs  

•  Activating/Deactivating a Job or a sub-job 

•  How to disable a Start component 

•  How to disable a nonStart component 

•  Importing/exporting items or Jobs 

•  How to import items

•  How to export Jobs to an archive 

•  How to export items

•  How to change context parameters in Jobs 

•  Managing repository items

•  How to handle updates in repository items 

•  Searching a Job in the repository 

•  Managing Job versions 

•  Documenting a Job 

•  How to generate HTML documentation 

•  How to update the documentation on the spot

•  Handling Job execution 

Chapter 5 

•  Mapping data flows 

•  tMap operation 

•  Setting the input flow in the Map Editor 

•  Mapping variables 

•  Using the expression editor 

•  Mapping the Output setting Talend Open Studio

•  Setting schemas in the Map Editor 

•  Solving memory limitation issues in tMap use 

•  Handling Lookups 

•  tXMLMap operation 

•  Using the document type to create the XML tree

•  Defining the output mode 

•  Editing the XML tree schema 

Chapter 6

•  Managing Metadata  

•  Objectives 

•  Setting up a DB connection

•  Step 1: General properties 

•  Step 2: Connection 

•  Step 3: Table upload

•  Step 4: Schema definition   

• Setting up a JDBC schema

•  Step 1: Generalproperties 

•  Step 2: Connection 

•  Step 3: Table upload

•  Step 4: Schema definition 

•  Setting up a File Delimited schema 

•  Step 1: General properties 

•  Step 2: File upload 

•  Step 3: Schema definition 

•  Step 4: Final schema

•  Setting up a File Positional schema 

•  Step 1: General properties 

•  Step 2: Connection and file upload 

•  Step 3: Schema refining 

•  Step 4: Finalizing the end schema 

•  Setting up a File Regex schema 

•  Step 1: General properties 

•  Step 2: File upload 

•  Step 3: Schema definition 

•  Step 4: Finalizing the end schema 

•  Setting up an XML file schema 

•  Setting up an XML schema for an input file 

•  Setting up an XML schema for an output file 

•  Setting up a File Excel schema 

•  Step 1: General properties 

•  Step 2: File upload 

•  Step 3: Schema refining 

•  Step 4: Finalizing the end schema  

Chapter 7

• Datawarehousing Concepts

• ETL Concepts

• tsortrow

• tunite

• tuniqerow

• tbufferinput

• tbuffer output

• thashinput

• thashoutput

• tfilelist

• tsleep

• tloop

• file input output components

• database input output components

• tsendmail

• treplicate

• tfiltercolumns

• tfilterrows

• treplace

• tconverttype

• tdie

• tcontextload

• tmemorizerow

• trowgenerator

• trunjob

• prejob

• postjob

• tsamplerows

• tnormalize

• tdenormalize

• tmap

• taggrigator

• tjoin

• tsystem

• Dynamic

• tjava

• tjavarow

• tjavaflex

• tschemacompliancecheck

• tlogrow

• tlogcatcher

• t ststcatcher

• tparallelize

• tsendmail

• tfilecopy

• tfilearchive

• tfileProperties

• tfileunarchive

• tfiletouch

• tfiledelete

• tfileexist

• tfiletouch

• tfilecopy

• tftpfilelist

• tftpput

• tftpget

• tftpdelete

• tftpfileexist

• tftpConnection

• tftpRename

• tftpfileproperties

• toracleInput

• toraclerow

• toracleoutpt

• toracleconnection

• toracleBulk

• toracleBulkexec

• toracleClose

• toracleRollback

• toraclecommit

• tmssqlInput

• tmssqlrow

• tmssqloutpt

• tmssqlconnection

• tmssqlBulk

• tmssqlBulkexec

• tmssqlClose

• tmssqlRollback

• tmssqlcommit

• tDb2Input

• tDb2row

• tDb2outpt

• tDb2connection

• tDb2Bulk

• tDb2Bulkexec

• tDb2Close

• tDb2Rollback

• tDb2commit

• OnsubJobOK

• OnSubjobError

• OnComponentOk

• OnComponentError

• runif

• tExcelInput

• tExceloutput

• tfileInputdelimited

• tfileoutputDelimited

• tfileInputXml

• tfileoutputXml

• tfileinputPositional

• tfileOutputPositional

• SCD1

• SCD2

• SCD3

•  stage loading

• Dimension Loading 

• fact Loading 

• project Explanation