Talend

Talend ETL Tool Training 

Course Description:

Module 1: Getting started with Talend Open Studio

  • Studio Definitions
  • Starting the studio
  • Creating the project
  • Everything about Talend GUI
  • Creating an example job

Module 2: Working with Metadata

  • Difference Between Built-in Schema and Repository Schema
  • Propagating Schema Changes
  • Dropping Schema to empty components
  • Cutting, Copying and Pasting schema information

Module 3: Working with Files

  • Reading Delimited files
  • Reading Positional Files
  • Reading Excel Files
  • Reading XML Files
  • Reading HL7 Files

Module 4: Usage of Database Components in Talend

  •    tOracleConnection
    • tOracleCommit
    • tOracleRollback
    • tOracleClose
  •    tOracleInput
  •    tOracleOutput,Bulk and Bulk Execution
  •    tOracleRow

Module 5: Using tMap

  • Overview of  tMap
  • Connecting multiple inputs to tMap
  •  Join options in tMap
  • Catching Rejects in tMap
  • Using Expression Builder in tMap
  • Using Variables in tMap
  • Performance tuning of look ups in tMap

Module 6: Usage of Processing Components in Talend

  •  tJoin
  •  tFilterRow and tFilterColumn
  •  tAggregateRow
  •  tSortRow
  • tReplace
  • tNormalize
  • tDeNormalize

Module 7: Using Java in Talend

  • Creating Routines in Talend
  •  Using Custom Code in Talend
  •  Using tJava component
  •  Using tJavaRow component
  •  Using tJavaFlex component

Module 8: Orchestration and Data Quality Components in Talend

  • tFileList , tFileCopy,tFileDelete,tFileExist and tWaitForFile
  • tFlowtoIterate and tIteratetoFlow
  • tUnite ,tReplicate
  • tPrejob,tPostjob
  • tUniqRow and tReplace
  • tSchemaComplianceCheck

Module 9: Configuring Statistics and Logs in Talend

  • Capturing Statistics at Project Level
  • Using tWarn, tDie, tFlowMeter
  • Using tFlowMeterCatcher, tLogcatcher
  • Using Global Variables in Talend

Module 10: Preparing for Deployment

  • Creating Context variables
  • Creating Context group
  • Usage of Prompts in Talend Jobs
  • Running Jobs in different contexts
  • Using tContextLoad
  • Using tContextDump

Module 11: Creating Sub jobs

  • Using tRunJob
  • Passing parameters to Sub Job
  • Passing context variables from Parent Job to Child Job
  • Passing context variables from Child Job to Parent Job

Module 12: Data warehousing Basics

  •  Data warehousing Architecture
  • Dimension Tables
  • Fact Tables
  • Types of Schema
  • Slow Changing Dimension
  • OLAP and OLTP

Module 13: Using SCD Components in Talend

  • Using SCD Type 1 implementation
  • Using SCD Type 2 implementation
  • Using SCD Type 3 implementation

Module 14: Miscellaneous

  • Export and Import Talend Jobs/Projects
  • Performance Tuning in tMap
  • Performance Tuning tips.
  • Multithread Execution.
  • OnsubJob ok ,Oncomponent ok ,Runif

Module 15: Case Study/ Project – Building a Retail Data warehouse

  • Discussing Business Requirements Document
  • Creating Staging Load Jobs
  • Creating Dimension Load Jobs
  • Creating Fact Load Jobs

Module 16: Designing a Business Models in Talend

  • Opening/Creating a Business Model
  • Modelling a Business Model
  • Assigning Repository elements to a Business Model

Module 17: Big Data Over view

  • Big Data over view .
  • Working with Big data components.

Module 18: FTP components

  • FTP connection
  • ftp Get
  • ftp put
  • ftp filelist
  • ftp delete….

Module 19: Memory components

  • Hash Input
  • Hash Output
  • Buffer Input
  • Buffer Output

Comments are closed