What Does the Course Cover ?
- What does the course cover ?
- How to Download The Data files and Job files ?
Introduction To Talend Open Studio
- Introduction
- Concepts and Principles of Data Integration
- Introduction to Talend Open Studio
- Installing Talend Open Studio DI on Windows
- Installing Talend Open Studio DI on Linux and Mac
Talend Open Studio GUI
- Introduction
- Launching Talend Studio
- MainWindow, MenuBar and ToolBar
- Repository Panel
- WorkSpace And Pallete Panels
- Views And Summary Panels
- Designing a Simple Job
Designing a Business Model
- Introduction
- What is a Business Model ?
- How to Create a Business Model ?
- What are the different types of shapes and How are they Used ?
- What are Different Relationship Types in a Business Model ?
- Deep Dive into Business Model View
- How to Assign any Repository Object to A Business Model ?
- How to Edit a Business Model ?
All about Metadata Management and Database Schemas
- Introduction
- What is Metadata ?
- Creating Metadata For a Delimited File
- Creating Metadata For a Positional File
- Creating Metadata For a Regex File
- Creating Metadata For a XML File
- Creating Metadata For an Excel File
- Creating Metadata For a LDIF File
- Creating Metadata For a Json File
- Creating Generic Schema
- Creating Metadata For a Web Service
- Creating a Database Connection
- [Exercise: 01] Create Builtin Schema
- [Exercise: 02] Create Generic Schema
- [Exercise: 03] Make Changes to Repository Schema and Propagate Changes
- [Exercise: 18] Create Database Connection & Retrieve Schema
Contexts And Global Variables
- Introduction
- What are Context Variables ?
- Creating a context group
- How to apply context variables to a Job
- How to Load context Values Dynamically from a flow or File or Database ?
- Using implicit context loading to load contexts
- How to Use Studio global variables
- How to Create User defined global variables
- Using tSetGlobalVar to create Global Variable
- [Exercise: 13] Create a Context and Create a globalMap Value Using tJava
- [Exercise: 16] Load Context Values from a file
- [Exercise: 17] Setup Implicit Context File Location
- [Exercise: 48] Create a User Defined Global Variable and Pass it as a parameter
- [Exercise: 62] Create a User Defined Global Variable and Use it
- [Exercise: 63] Load a Context Value from a Properties File
- [Exercise: 64] Use and Print any Global Variable to Console
- [Exercise: 65] Create a Global Variable Using tSetGlobalVar
Designing a Talend Standard Job
- Introduction
- What is a Job Design ?
- How to Create a Job ?
- How to Design a Talend Job ?
- How to Link different Components ?
- How to Define Component Properties ?
- How to Use Contexts and Variables in a Job ?
- How to optimize Job Performance ?
Managing Talend Jobs
- Introduction
- How to Import/Export Items and Build Jobs ?
- How to Manage Repository Items ?
- How to Document a Job ?
- How to Handle Job Execution ?
File Management
- Introduction
- How to Read Data From an Apache Log File ?
- How to Read Data From an ARFF File ?
- How to Read Data From a Delimited File ?
- How to Read Data From an Excel File ?
- How to Read Data Complete Row as a Column From a File ?
- How to Read Data From a JSON File ?
- How to Read Data From a LDIF File ?
- How to Read Data From an Email File ?
- How to Read Data From a Multi Structured Delimited File ?
- How to Read Data From a Positional File ?
- How to Read Data From a Multi Structured Positional File ?
- How to Read Data From a XML File ?
- How to Read Data From a Multi Structured XML File ?
- How to Read Data From a Properties File ?
- How to Read all the content of a file and Send it to a Single column ?
- How to Read Data From a Regex File ?
- How to Write Data To an ARFF File ?
- How to Write Data To a Delimited File ?
- How to Write Data To an Excel File ?
- How to Write Data To a JSON File ?
- How to Write Data To a LDIF File ?
- How to Write Data To a Multi Structured Delimited File ?
