Duration
2 days
What you'll learn
- Students will get fair understanding of Talend Open Studio and will be able to think about the scenarios and solve it using Talend.
- Create ETL jobs that connect to almost any data source
- Filter, Modify, Unite data
- Build standalone jobs that run on a schedule or based on an event
- Make jobs more user-friendly for non technical users
Who this course is for
- IT Professionals, ETL Developers, Students Interested In ETL Tools
- A bit of Java
- A bit of Databases, How RDBMS DB's work
- SQL syntax
Requirements
- The students should have basic understanding of Talend Open Studio Designer.
Course Outline
Talend intro
Introduction
- Windows Installation
- Talend UI
- Taking a look at the Repository Tab
- Repository Tab in more detail
- Context and Metadata
- More on Context and Metadata
- Headers
Data Mapping
- Mapping Data
- Data Generation
- Outputing tMap Rejects
- Filtering Mapped Data
- Mapping Database Data
Conversion, Extraction, Join
- Regex Expressions
- XML to CSV conversion
- CSV to XML conversion
- Advanced XML
- Joining Data
- Splitting Data
- Performing Advanced Data Lookups
- Uniting Data
Helpful features
- Retreating and working with File Properties
- Row Count
- Temp, Delete, Move, Rename
Java
- Basics tJava component
- More features of tJava component
- tJavaRow component
- tJavaFlex component
- Custom Routines
Databases
- Databases in Talend
- Working with Hyper SQL (HSQL)
- Looking at Table Schema's
- Importing Table Schema's
- Reading Data from a Database
- Writing Data to a Database
Debugging, Logging, Building, Scheduling
- Debugging
- Reject Handling
- Reject Handling with tMsgbox component
- Saving Console Log to a flat file
- tMap Input Reject Handling
- Logging Job Information
- Monitoring Jobs
- Building Talend Jobs
- Adding context from command line
- Additional context variable modifications
- Scheduling Talend Jobs
Extras
- Sub Jobs
- Custom Components
- Creating a job with tFileExcel* (Custom Components)
- Using tSystem Component
- Using tSCP* components
Programme scope, delivery arrangements and suitability are confirmed during enquiry.