Radical Technologies
Call :+91 8055223360 | 8103400400

TALEND

Satisfied Learners

Talend Training Institute in Pune

Duration of Talend Training: 30 hrs

Number of Sessions: 27

Mode of Training : Classroom | Online | Corporate

Weekend / Weekdays Batches Available

Centers: Radical Technologies Aundh | Kharadi | Pimple Saudagar | Hinjewadi | Karve Road | Magarpatta

Talend Introduction
Learning Objectives: In this module, you will get an overview of ETL Technologies.You will be introduced to various products offered by Talend Corporation till date and its relevance to Data Integration. Further, you will learn about the TOS (Talend Open Studio), GUI, and how to install TOS.
Topics:
• Working with ETL
• Comparison with other market leader tools in ETL domain
• Importance of Talend (Why Talend)
• Talend and its Products
• Introduction of Talend Open Studio
• TOS for Data Integration
• GUI of TOS with Demo
Hands-on/Demo:
• Creating a basic job
Working with Talend for Data Integration
Learning Objectives: In this module, you will learn to work with various types of Data Source, Target Systems supported by Talend, Metadata and how to read/write from popular CSV/Delimited files. Connect to a Database and read/write/update data and complex datatypes like JSON along with some of the basic components like tLog, tMap using TOS.

What you will learn

  • Start Talend Open Studio for Data Integration
  • Create a Talend project to contain tasks
  • Create a Talend Job to perform a specific task
  • Add and configure components to handle data input, data transformation, and data output
  • Run a Talend Job and examine the results
  • Extend data from one source with data extracted from a second source
  • Log data rows in the console rather than storing them
  • Execute Job sections conditionally
  • Duplicate output flows
  • Create variables for component configuration parameters
  • Connect to a database from a Talend Job
  • Use a component to create a database table
  • Write to and read from a database table from a Talend Job
  • Filter unique data rows
  • Perform aggregate calculations on rows
  • Export a Job
  • Run an exported Job independently of Talend Open Studio
  • Create a new version of an existing Job 

Course Outline:

  • Starting Talend Open Studio
  • Creating a Job
  • Reading Input
  • Transforming Data
  • Running a Job
  • Combining Columns
  • Building a Business Model
  • Duplicating a Job
  • Creating Metadata
  • Creating a Join
  • Capturing Join Failures
  • Correcting the Lookup
  • Updating the Business Model
  • Generating Rows
  • Creating the Join
  • Adding Constraints
  • Replicating Output
  • Using Context Variables
  • Using Repository Context Variables
  • Handling Errors
  • Working with Databases
  • Creating a New Project
  • Creating Customer Metadata
  • Creating the Customer Table
  • Creating the Product Table
  • Setting up Sales Files
  • Setting Up the Shop Staging Table
  • Joining the Data
  • Finalizing the Job
  • Documenting the Job
  • Running Jobs Standalone
  • Exporting a Job

Topics:

Sessions Topic Name
1 Introduction and Architecture
2 Talend Installation overview
3 Talend UI
4 Understanding Repository Tab
5 Context of Metadata Basics and Advanced
6 Headers
7 Mapping Data
8 Data Generation
9 Output tMap rejects, Filtering, Database data
10 Conversions using Expressions
11 XML to CSV
12 CSV to XML
13 Advanced XML
14 Joining Data
15 Splitting data
16 Advanced data lookups
17 Uniting data
18 Working with File Properties
19 Row Count
20 Temp, delete, move, rename
21 Basic and more features of tJava components, Custom routines
22 Data bases in Talend
23 Working with Hyper SQL, importing table schema,reading and writing data to DB
24 Debugging – Reject handling, Building jobs, Monitoring jobs
25 Adding context from command line,context variable modifications
26 Scheduling jobs
27 Custom components (Creating a job with tFileExcel),tSCP & tSystem

 

 

Our Courses

Drop A Query

Call Now ButtonCall Us