• Post category:StudyBullet-16
  • Reading time:7 mins read


Learn Talend Architecture, ETL Components, Logging and Error, Databases, Flat files, Streaming, AWS Cloud and Kafka

What you will learn

Talend

ETL Using Talend

Talend Open Studio for Big Data

Talend General and Big Data Components

Description

The course is about Talend ETL processing.

Talend enables us to deliver complete, clean, and uncompromised data to make every decision count. It collects the right data from diverse sources at the speed your business demands. It shares trusted data across departments and platforms, safely and securely. It also delivers trusted data to the people who need it, when they need it and improve your control of data to make better decisions and build high-impact digital experiences.

Talend is the leading open source solution for data integration. Its capabilities include,

  • Connectors topackaged applications (ERP, CRM, etc.), databases, mainframes, files, Web Services, and so on to address the growing disparity of sources.
  • Writingto data warehouses, data marts, OLAP applications – for analysis, reporting, dashboarding, scorecarding, and more.
  • Built-in advanced components for ETL, including string manipulations, Slowly Changing Dimensions, automated lookup handling, bulk loads support, etc

In this course you will learn about


Get Instant Notification of New Courses on our Telegram channel.


  • Talend Architecture
  • ETL Components
  • System Components
  • Logging and Error
  • Interacting with Databases
  • Interacting with Flat files
  • Streaming process
  • AWS Cloud
  • Kafka

This Course is for,

  1. ETL Developers
  2. Data Architects
  3. ETL Engineers
  4. Data Engineers
  5. ETL Architects
  6. Database developers
  7. BI Developers

You would learn all the below components,

tAggregatorRow tFileCopy tFilterColumns tRunJob tWarn tAssert tFileDelete tFlowMeter tSampleRow tChronometer tFileExist tJoin tSetEnv tConvertType tFileInputDelimited tLogCatcher tSortRow tCreateTemporaryFile tFileList tLogRow tSplitRow tDenormalize tFileOutputDelimited tMap tSSH tDie tFileProperties tNormalize tStatCatcher tExtractDelimitedFields tFileTouch tReplace tSystem tFileArchive tFileunarchive tReplicate tUniqueRow tFileCompare tFilter tRowGenerator tUnite

English
language

Content

Introduction

About the Course
Downloading Talend
Introduction to Talend and its Architecture

Starting with Talend

Creating Metadata
Loading data from Oracle to PostgreSql
Loading data from Flat File to Database Table

Database Source & Target Components (Input & Output Components)

Source
Target

Working with Components

tMap
tLogRow
tJoin
tRowGenerator
tSampleRow
tAggregatorRow
tFilterRow
tFilterColumns
tSortRow
tReplace
tUnite
tUniqueRow
tReplicate
tConvertType
tSplitRow
tExtractDelimitedFields
tNormalize
tDenormalize

OnSubJobOk, OnSubJobError, OnComponentOk, OnComponentError & RunIf

Introduction
OnSubJobOk
OnSubJobError
OnComponentOk & OnComponentError
RunIf

Working with File Components

tFileInputDelimited
tFileOutputDelimited
tFileList
tFileCopy
tFileDelete
tFileCompare
tFileExist
tFileProperties
tFileTouch
tCreateTemporaryFile
tFileArchive
tFileunarchive

System Components

tRunJob
tSystem
tSetEnv
tSSH

Logs & Errors

tAssert & tAssertCatcher
tChronometerStart & tChronometerStop
tDie
tFlowMeter & tFlowMeterCatcher
tLogCatcher
tStatCatcher
tWarn

AWS & Talend

Working with S3 buckets using Talend – Part1
Working with S3 buckets using Talend – Part2
Load CSV to RDS
Load data from S3 to RDS

Kafka & Talend

Create Kafka Topic using Talend
Kafka to Talend Streaming
Talend to Kafka Streaming