Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Talend Data Integration (ETL)

No Reviews Yet

Course type: Online Instructor led Course

Platform: GoToMeeting

Course ID: 28648

Course type: Online Instructor led Course

Platform: GoToMeeting

₹ 12,000

Raj picture
Raj
No Reviews Yet

Date and Time

Not decided yet.

Raj picture
Raj

Informatica & Oracle Certified Professional

About Raj

Expert in ETL, Data Integration, Data Quality & Metadata Management
No reviews currently

About the Course

Talend Studio for Data Integration dramatically improves the efficiency of data integration Job design through an easy-to-use graphical development environment. It enables rapid deployment and reduces maintenance costs with integrated connectors to all source and target systems, with support for all types of data integration, data migration, and data synchronization operations.

This course enables you to use Talend Studio for Data Integration for real work as quickly as possible. It focuses on the basic functionality of the Studio and how it can be used to build reliable, maintainable data integration tasks that solve practical problems: extracting data from common database and file formats, transforming it, and integrating it into targets.
The skills learned in this course are applicable to most Talend products.

This course serves as the basis for all Talend training courses

Topics Covered

Lesson 1 - Introduction to Talend Open Studio for Data Integration
• Overview Studio
• Settings
• First Jobs
• Edit Schema
• Create Metadata
• Create Database Connection

Lesson 2 - Getting Started with Jobs development
• Creation of a Sample Job
• Using tMap, tLogRow in the Job

Lesson 3 - Concepts of Joining Data Sources
• Join using tMap
• Join using tJoin
• Capturing Join errors in tMap
• Differences b/w tMap joining and tJoin

Lesson 4 - Concepts of Filtering Data
• Filter using tMap
• Filter using tFilterRow
• Differences b/w tMap filtering and tFilterRow
• Column filtering with tFilerColumn

Lesson 5 & 6 - Talend Components
• Sorting and Aggregation - tSort, tAggregate, tAggregateSortedRow
• Normalization and Denormalization - tNormalize, tDenormalize, tExtractDelimitedRows, tSplitRow
• tUnite
• tUniqRow
• tConvertType
• tReplicate

Lesson 7 - File Processing
• tFileInputDelimited, tFileOutputDelimited, tFileInputPositional, tFileOutputPositional
• tFileInputMSDelimited, tFileInputMSPositional
• tFileInputRegex, tFileInputExcel
• tFileTouch, tFileExist
• tFileList

Lesson 8 - XML Processing
• tFileInputXML, tFileOutputXML
• tExtractXMLField, tWriteXMLField
• tXMLMap

Lesson 9 - Web Services
• Accessing a Web Service
• Detailed output
• Documenting the Job

Lesson 10 - Concepts of ELT
• tELTOracleInput, tELTOracleOutput
• tELTOracleMap, tOracleSCDELT

Lesson 11 - Context Variables
• Local Context Variables
• Global Context Variables
• Context Groups

Lesson 12 - Monitoring Job Activity
• Configuring statistics and logging
• Using Activity Monitoring Console

Lesson 13 - Change Data Capture
• Examining the databases
• Configuring Change Data Capture
• Monitoring changes
• Updating repository

Lesson 14 - Slowly Changing Dimensions
• Manual SCD Job Build
• Build using SCD Components

Lesson 15 - Joblet
• Joblet creation from an existing Job
• Joblet creation from scratch
• Triggering Joblet
• Writing to database

Lesson 16 - Nested Jobs
• Parent & Child Jobs
• Calling Context Variables across Jobs
• Passing data across Jobs

Who should attend

Anyone who wants to use TalendData Integration to perform data integration and management tasks. Examples include project managers, business intelligence experts, system engineers, DBA and Java development engineers.

Pre-requisites

Basic knowledge in computing, including familiarity with Java or another programming language, as well as SQL or other general concepts of databases.

What you need to bring

Good internet connectivity (2 MBPS) and machine with minimum of 4 GB RAM is required for installation and configuration.

Key Takeaways

After completing this class, you will be able to:
• Start and connect Talend Studio to a remote repository
• Configure a database to monitor changes in a separate CDC database
• Configure a Talend project to capture statistics and logs
• Use parallel execution in a Talend Job

Reviews

No reviews currently

Discussions

₹ 12,000

Post your requirement and let us connect you with best possible matches for ETL Training Post your requirement now
₹ 12,000 Enquire