Duration
2 days
What you'll learn
- Building Talend ETL Jobs Step by step
- ETL AND ELT using Talend
- Developing Complex ETL Pipelines
- Best Practices of Talend ETL development
- Writing Custom Code in Talend
- Talend Exceptions Handling
- Talend Error Handling
Who this course is for
- IT Professionals, ETL Developers, Students Interested In ETL Tools
- A bit of Databases, How RDBMS DB's work
- Anyone who want to build their career in ETL
Requirements
Basic Knowledge of Databases, SQL and Java Language is Required
Introduction
- Basic Concepts: Connections and Triggers in Talend
- Basic Concepts: Context Variables and Global Variables in Talend
- Basic Concepts: Component based Variables
- Basic Concepts: How to Lay out Components
- Basic Concepts: Jobs, Sub-Jobs, Child-Jobs and Components
- Basic Concepts: What is Metadata?
- Managing External API's and Libraries
Talend Schema Concept
- What is Data Schema? Schema Manual Definition Process
- Schema Automatic Retrieval for Complex Schema Files
- Schema Good and Bad Records Pipelining
Flat Parsing in Talend
- Flat Files Parsing
- MS Excel Files Parsing
- JSON Files Parsing
- Multi-Schema Files Parsing
Databases Management in Talend
- Database Best Practices: General, Data Reading and Data Writing
- Database Bulk Insert Components
- Database Tables/Views Schema Retrieval
- Talend Built-In SQL Editor
- SQL Parametrized
- Execute Multiple SQL in One Component
- Database Row by Row Handling
Mapping and Lookups
- What type of Joins Talend Support
- How to perform Inner Join
- How to perform Inner Join Right Table Reject
- How to perform Left Join
- How to perform Right Join
- tMap Component in detail
Jobs Optimization Concepts
- Parent Job to Child Job Data Transfer
- Child Job to Parent Job Data Transfer
- How to see Parent Child Job Hierarchy
- Custom Java Code Components
- In-Memory Data Storage Components
Managing Loops in Talend
- For and While Loop (tLoop)
- tForEachLoop
- Infinite Loop (tInfiniteLoop)
- Converting a Data Flow to Iterate Flow
- Converting an Iterate Flow to Data Flow
Major Transformations in Talend
- How to Normalize Data (tNormalize)
- How to deNormalize Data (tDenormalize)
- How to Multicast/Replicate Data Flows
- How to Remove Duplicates from data
- How to Combine Multiple Data Flows
- How to Pivot Columns to Rows
Exceptions and Error Handling
- Exceptions Handling, Errors Handling, Jobs Logging
- What is Talend Exchange?
- Installing a Talend Exchange Component
- Executing a Talend Exchange Component
Programme scope, delivery arrangements and suitability are confirmed during enquiry.