TALEND
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 |
