Data Mapper Basics

Talend Data Mapper (TDM) is a tool for working with complex hierarchical data. For example, data can have nested or looped structures.

This course familiarizes participants with the most popular features of TDM.

Duration1 day (7 hours)
Target AudienceJava application developers and software architects.
PrerequisitesGeneral understanding of Java. Completion of the Data Integration Basics course.
Course Objectives
After completing this class, you will be able to:
  • Import and create structures for XML files and flat files
  • Build and run TDM Jobs using its most common features
  • Create TDM Jobs that read files, transform data, and return outputs
Course AgendaLesson 1 - Creating a simple XML-to-XML mapping
  • Describing the exercise
  • Creating a simple XML-to-XML mapping
  • Creating a mapping using POXML
Lesson 2 – Simple loops
  • Describing the exercise
  • Preparation
  • Creating a new mapping
  • Selecting and testing the input
  • Adding and testing a filter
Lesson 3 - Nested loops
  • Describing the exercise
  • Preparation
  • Creating a new mapping
  • Selecting and testing the data source
Lesson 4 – Aggregation loops
  • Describing the exercise
  • Preparation
  • Creating a new mapping
Lesson 5 - Adding functions
  • Describing the exercise
  • Creating a concatenation function
  • Creating If/Then/Else conditions
Lesson 6 - Creating a COBOL to XML Map
  • Describing the exercise
  • Creating input structure
  • Creating output structure
  • Creating a new mapping
Lesson 7 - Using tHMap with data integration columns
  • Describing the exercise
  • Properties of structural elements
  • Using tHMap with data integration columns
Lesson 8 - Using cMap
  • Describing the exercise
  • Configuring the cFile component and creating the route structure
  • Importing account structure
  • Creating JSON structure
  • Creating an XML-to-JSON mapping
  • Configuring cMap and testing the route
Lesson 9 – COBOL to Excel
  • Describing the exercise
  • Create new structure
  • Create mapping
  • Show document