Talend DI + TMC + AWS - Zero to Hero

Discover the Talend Studio interface—from repository to configuration tab, including palette and outline; create projects, manage workspaces, drag and drop components, and review the generated Java code.

Explore extracting data from an Excel file using Talend's tFileInputExcel with a built-in manual schema, and print results to the console while configuring sheets, headers, and column data types.

Learn to extract data from a comma-delimited file using tFileInputDelimited, configure schema with first name, last name, department, and salary, set header and delimiter, and print results to the console.

Extract data from Excel and delimited files using built-in, manual, and metadata-driven repository schemas in Talend DI; set headers and encoding, then auto-build and reuse schemas for seamless input.

Learn to extract data from a database table with built-in manual schema and metadata using tDBInput in Talend, printing results to the console and reusing connections.

Explore the tFilterRow processing component to transform data in the ETL workflow. Filter records by age and name length, and route nonmatching rows to the rejection using an employee table.

Learn to sort data with the tSortRow component in Talend DI, using multiple criteria (employee number, first name, last name) in ascending or descending order, with SQL-like order by concepts.

Load data from a database into an Excel file and a delimited csv using db input and tFileOutputExcel and tFileOutputDelimited, including sheet names, headers, and append versus overwrite options.

Learn to load data from Excel and delimited files into database tables using a DB output component, with connection reuse, metadata creation, and table options like create, drop, or truncate.

Discover the types of connections in Talend DI, including main connection, lookup, filter, output, unique and duplicate, iterate, and triggers, plus on sub job versus on component for error handling.

Learn to use tFileList for scalable file management by iterating over all files with the same schema in a folder, using file masks, and loading them into a single table.

Load six employee txt files from the client folder, copy each to a loaded folder, and delete the originals with tFileCopy and tFileDelete in a Talend DI workflow.

Archive and unarchive with tFileArchive and tFileUnarchive by zipping an input folder into a talent folder, and unzipping to a destination folder with zip or gz options, encoding, and password.

Master file compare with tFileCompare in text and binary modes, observe differences, and use tFileRowCount to count CSV rows while tFileProperties reveals path, size, and optional MD5.

Learn how the tMap component in Talend enables imap transformations, configuring a map window with inputs, outputs, and variables, and applying filters and or conditions to shape data.

Master tMap advance by creating variables and expressions, applying date and string functions, concatenating names, and splitting data into multiple outputs across extract, transform, and load stages.

Master tMap join in Talend, covering left, right, inner, and full joins, by mapping employee and employee details tables and validating outputs for data integration.

Explore tAggregateRow and tAggregateRowSorted to group data by location and compute counts and salary statistics. Learn why sorting input is essential for aggregate sorted row to produce correct results.

Learn to normalize and de normalize data with Talend components, turning semicolon-delimited skills into multiple rows, and use the td normalized sorted row for correct results.

Learn to filter rows from an input file with tSampleRow by selecting specific rows and ranges (2..8, 13..15, 30, 40..100) and generating multiple outputs with replicate.