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
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.
Intellipaat is the market leader in providing training for data integration and ETL tools. This Intellipaat Talend training will help you master one of the most powerful open-source platform that is deployed in data integration and ETL. You will learn Talend Open Studio, data aggregation methods, T Map and its properties. This training also includes multidimensional data modeling, learning Talend architecture and data management techniques. The entire training is in line with clearing the Talend Data Integration Certified Developer exam.
You will be working on real-time projects and step-by-step assignments that have high relevance in the corporate world, and the course curriculum is designed by industry experts. Upon the completion of the training course, you can apply for some of the best jobs in top MNCs around the world at top salaries. Intellipaat offers lifetime access to videos, course materials, 24/7 support and course material upgrading to the latest version at no extra fee. Hence, it is clearly a one-time investment.
This Talend training course is designed for clearing the Talend Data Integration Certified Developer exam. The entire course content is in line with the certification program and helps you clear the certification exam with ease and get the best jobs in top MNCs.
As part of this training, you will be working on real-time projects and assignments that have immense implications in the real-world industry scenarios, thus helping you fast-track your career effortlessly.
At the end of this training program, there will be a quiz that perfectly reflects the type of questions asked in the certification exam and helps you score better marks.
Intellipaat Course Completion Certificate will be awarded upon the completion of the project work (after the expert review) and upon scoring at least 60% marks in the quiz. Intellipaat certification is well recognized in top MNCs like Ericsson, Cisco, Cognizant, Sony, Mu Sigma, Saint-Gobain, Standard Chartered, TCS, Genpact, Hexaware, etc.