TALEND TRAINING IN PUNE | ONLINE
Duration of Training : 32 hrs
Batch type : Weekdays/Weekends
Mode of Training : Classroom/Online/Corporate Training
Talend Training & Certification in Pune
Highly Experienced Certified Trainer with 10+ yrs Exp. in Industry
Realtime Projects, Scenarios & Assignments
Why Radical Technologies
CENTERS :
Radical Technologies – Aundh | Kharadi | Pimple Saudagar | Hinjewadi |
Karve Road | Magarpatta
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 |
Learn Talend – Course in Pune with Training, Certification & Guaranteed Job Placement Assistance!
Online Batches Available for the Areas
Ambegaon Budruk | Aundh | Baner | Bavdhan Khurd | Bavdhan Budruk | Balewadi | Shivajinagar | Bibvewadi | Bhugaon | Bhukum | Dhankawadi | Dhanori | Dhayari | Erandwane | Fursungi | Ghorpadi | Hadapsar | Hingne Khurd | Karve Nagar | Kalas | Katraj | Khadki | Kharadi | Kondhwa | Koregaon Park | Kothrud | Lohagaon | Manjri | Markal | Mohammed Wadi | Mundhwa | Nanded | Parvati (Parvati Hill) | Panmala | Pashan | Pirangut | Shivane | Sus | Undri | Vishrantwadi | Vitthalwadi | Vadgaon Khurd | Vadgaon Budruk | Vadgaon Sheri | Wagholi | Wanwadi | Warje | Yerwada | Akurdi | Bhosari | Chakan | Charholi Budruk | Chikhli | Chimbali | Chinchwad | Dapodi | Dehu Road | Dighi | Dudulgaon | Hinjawadi | Kalewadi | Kasarwadi | Maan | Moshi | Phugewadi | Pimple Gurav | Pimple Nilakh | Pimple Saudagar | Pimpri | Ravet | Rahatani | Sangvi | Talawade | Tathawade | Thergaon | Wakad