loading......

coming soon

Coming Soon

We are in process of building the inventory of good professionals in this category

Got it!

Where do you need ?

location

Please select a Location.

Enquire

Submit your enquiry for Talend Data Integration (ETL)

Please enter valid question or comment

Please enter your name.

Please enter valid email

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Raj

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

Share

Talend Data Integration (ETL)

Talend Data Integration (ETL)

Online Instructor led Course

Platform: GoToMeeting

12,000

3 Reviews
1 Interested

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

Recommendations & reviews from previous Customers:

Kishan

"Talend training was good from Raj. He gave good comparison between Talend and Informatica that makes me correlate and learn better as I was working on Informatica and totally new to Talend. "

attended Talend Data Integration (ETL)


Varun

"I've taken Talend training from Raj and it was a really helpful training. Talend being new technology not so many out there are able to give a good understanding of it but Raj did. Thanks Raj. "

attended Talend Data Integration (ETL)


Gatha

"Good learning experience I have had with Raj. Clear explanation of concepts with reference to the real time implementations is the best way of teaching followed by him. "

attended Talend Data Integration (ETL)


Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask


Recommendations & reviews from previous Customers:

Kishan

"Talend training was good from Raj. He gave good comparison between Talend and Informatica that makes me correlate and learn better as I was working on Informatica and totally new to Talend. "

attended Talend Data Integration (ETL)


Varun

"I've taken Talend training from Raj and it was a really helpful training. Talend being new technology not so many out there are able to give a good understanding of it but Raj did. Thanks Raj. "

attended Talend Data Integration (ETL)


Gatha

"Good learning experience I have had with Raj. Clear explanation of concepts with reference to the real time implementations is the best way of teaching followed by him. "

attended Talend Data Integration (ETL)


Date and Time

Not decided yet.

About the Trainer

Raj picture

Raj

Informatica & Oracle Certified Professional


Expert in ETL, Data Integration, Data Quality & Metadata Management
Seats Left-

Students Interested 1

Course Id: 28648