TRAINING

Enroll Now

Talend Training  

Talend training learn Talend Open Studio that is a 360 degree solution for ETL. Talend is built as a powerful open source tool. You can get a detailed understanding of the various features and benefits of working on the Talend platform. This will also improve your Big Data skills.

Audience

• Data warehousing professionals, analyst, programmer
• Business analyst, BI developers
• Solution architect and data architect
• System administrators and integrators
• Thos wanting to be Data scientists

Talend Course Content

Data Modeling Concepts

Understanding the basics of Data Modeling, its significance and how to deploy Data Modeling in Data Warehouse environment.

Deep Dive into Data Modeling

The various types of Data Modeling, learning to perform Conceptual Data Modeling, Physical Data Modeling, Logical Data Modeling, understanding the scope and benefits of Data Modeling.

Multidimensional Data Modeling

The basic Architecture of multidimensional modeling, deploying Cubes to perform multidimensional modeling, understanding the concepts of Facts and Dimensions and the differences between the two.

Introduction to Talend

The Talend Open Source data integration tool, working with Big Data, understanding the Talend Open Studio.

Talend Installation

Understanding the installation of Talend, system requirements, troubleshooting of common errors and issues related to installation.

Talend Key Features

Learning about the Talend Architecture, important concepts and features, Talend components like Job, Workspace, Metadata, Project, etc.

Talend Job Creation

Learning to create a Talend Job, working with Delimited file, working with Meta Data, schema for data integration, understanding Propagation, deploying of tFilterRow and string filter for creating Jobs, creation of CSV file.

Data Management Techniques

Deploying Talend Open Studio for Data Management, data quality, integration, understanding the ETL and Data Warehousing concepts.

Schema & Data Aggregation

Detailed understanding of Talend Job design, it features, learning about tMap, data aggregation techniques, tReplicate for performing different operations on a Schema, tMap for mapping input and output data.

DataSource Connection

Working with DataSource Connection, deploying in database component, creating a connection, database source and target, metadata and schema importing.

Talend Routines/Functions

Introduction to Talend Functions, calling and deploying the Functions, understanding Routines, Talend Open Studio for XML data processing, date format function.

Data Transformation

Transforming Data, Running the Job, Combining Columns, Duplicating a Job

Working with Metadata

Creating Metadata, Joining Data Sources.

Data Corrections

Capturing Rejects, Correcting the Lookup, Duplicating a Job

Data Filtering

Filtering Output Data, Using Multiple Filters.

Context Variables

Using Context Variables from Talend Job, Repository as Metadata.

Graphical Interface of Talend

Building Jobs, Graphical Jobs, Graphical Interface Of Talend, Talend’s Components Naming Convention

Trigger

Row – Main Connection, Row – Iterate Connection, Trigger – On sub Job ok Connection, Trigger – On Component OK Connection

File Management

File Management in Talend Connecting Talend with Hadoop Deploying Talend to work with Hadoop, defining the ETL method, Hive implementation with Talend, importing data in Hive, Hive partitioning, Pig in Talend, data loading and parallel data execution

Talend Project

Project : Creating Jobs using Metadata and using transformation steps

Industry : General

Problem Statement : How to create a Talend job using metadata

Topics : This project is involved with deploying metadata for creating a Talend job. You will be extracting data from multiple data sources like delimited, XML, MS Excel, database and transform the data based on logics provided and loading the data to data warehouse.

Highlight

• Extracting data from various types of data sources
• Database Connection with different databases
• Talend Job Creation