Talend Open studio ,database ,warehouse course by mahesh

About Talend Open studio ,database ,warehouse course by mahesh

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

Talend ETL Projects

Talend Open Studio

Talend for Big Data

Talend Real-Time Use Cases

Talend Component Tutorials

Talend Job Design

Talend with SQL

Talend SCD Type 1 2 3

Talend for Oracle / MySQL / PostgreSQL

Talend Interview Questions

Talend Deployment (TAC, TMC)

Talend Context Variables

Talend Data Integration

ETL Developer Training

ETL Testing and Automation

ETL Real Time Projects

ETL for Data Warehousing

ETL Interview Questions

Data Pipeline Development

Data Engineering Projects

End-to-End ETL Flow

Data Flow Design in ETL

Data Warehousing Fundamentals

Star Schema vs Snowflake Schema

Dimension and Fact Tables

Slowly Changing Dimensions (SCD)

DWH Design Patterns

Data Mart Development

BI & Data Warehouse

SQL for ETL

SQL Joins and Aggregations

SQL for Data Warehousing

Advanced SQL Queries

SQL Interview Prep

SQL Optimization for ETL

Talend AWS Integration

Talend with Cloud Services

Upload to S3 Bucket

Talend in Dev QA Prod Environments

Talend Agile Projects

Talend Domain Knowledge (Retail, Finance, Healthcare)

Talend Performance Tuning

Talend Error Handling

Talend Logging and Monitoring

Talend Looping & Iteration

Talend Real-Time Scenarios

Talend Project Architecture

Talend File Processing

Talend XML, JSON, Excel, Positional Files

Talend DB Bulk Load

Learn Talend from Scratch

Talend Certification Preparation

Talend Open Studio Tutorial

Real-Time ETL Projects for Beginners

How to Build ETL Pipelines in Talend

Data Engineering with Talend