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.
Understanding the basics of Data Modeling, its significance and how to deploy Data Modeling in Data Warehouse environment.
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.
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.
The Talend Open Source data integration tool, working with Big Data, understanding the Talend Open Studio.
Understanding the installation of Talend, system requirements, troubleshooting of common errors and issues related to installation.
Learning about the Talend Architecture, important concepts and features, Talend components like Job, Workspace, Metadata, Project, etc.
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.
Deploying Talend Open Studio for Data Management, data quality, integration, understanding the ETL and Data Warehousing concepts.
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.
Working with DataSource Connection, deploying in database component, creating a connection, database source and target, metadata and schema importing.
Introduction to Talend Functions, calling and deploying the Functions, understanding Routines, Talend Open Studio for XML data processing, date format function.
Transforming Data, Running the Job, Combining Columns, Duplicating a Job
Creating Metadata, Joining Data Sources.
Capturing Rejects, Correcting the Lookup, Duplicating a Job
Filtering Output Data, Using Multiple Filters.
Using Context Variables from Talend Job, Repository as Metadata.
Building Jobs, Graphical Jobs, Graphical Interface Of Talend, Talend’s Components Naming Convention
Row – Main Connection, Row – Iterate Connection, Trigger – On sub Job ok Connection, Trigger – On Component OK Connection
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
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.
Real- time Case Studies