EncartaLabs

Talend Data Mapper

( Duration: 2 Days )

The Talend Data Mapper training course, familiarizes attendees with the most popular features of TDM.

By attending Talend Data Mapper workshop, attendees will learn to:

  • Import structures from existing files and databases, or manually create them
  • Perform complex mapping and transformation between input and output structures
  • Harness the power of TDM from data integration Jobs or ESB Routes
  • Work with complex standards such as EDI and COBOL
  • Define and run test cases

  • Attend Talend Data Integration - Essentials or Talend Studio - Essentials course or equivalent experience, as well as a general understanding of Java

The Talend Data Mapper class is ideal for: Java developers and software architects

COURSE AGENDA

1

TDM in context

  • Concepts
2

Creating a simple JSON to JSON map

  • Creating a structure
  • Creating a map
3

Simple looping

  • Preparing the environment
  • Using simple loops
  • Sorting by item quantity
  • Filtering data
4

Nested looping

  • Creating a map using nested loops
5

Aggregation looping

  • Aggregating data
6

Using more functions

  • Using a concatenation function
  • Using an if-then-else condition
7

Using the tHMap component

  • Using the tHMap component
  • Reusing an existing map
8

Using context variables

  • Using context variables
9

Defining and running test cases

  • Setting up a test case
10

Using the cMap component

  • Creating a Route
  • Creating XML to JSON mapping
  • Configuring cMap and testing the Route
11

Using the tHMapFile component

  • Creating a Big Data Job
  • Creating XML to JSON mapping
  • Using the tHMapFile component
12

Instructions for optional modules

  • Navigating optional modules
13

EDI - Mapping the EDI format

  • Embedding multiple representations
  • Creating a map
14

EDI - Refactoring

  • Upgrading output inheritance
  • Upgrading output mapping
  • Upgrading input inheritance
15

COBOL - Handling COBOL redefined fields (RDEF)

  • Creating a COBOL structure
  • Configuring the structure for redefined fields
16

COBOL - Mapping COBOL to Excel

  • Creating a structure
  • Creating a DI Job
17

COBOL - Flattening a looping COBOL structure

  • Creating a Job
18

COBOL - Mapping COBOL to XML

  • Creating a COBOL structure
  • Creating a map
19

SWIFT - Working with SWIFT structures

  • Creating a SWIFT structure
  • Creating F30 and F20 fields
  • Creating F31P and F35B fields
  • Creating F35A and F83D fields
  • Creating an F87D field
20

SWIFT - Mapping SWIFT files to MySQL

  • Setting up a MySQL connection
  • Creating a DI Job
  • Performing mapping
  • Running the Job
21

SWIFT - Mapping multiple record types

  • Creating an input structure
  • Creating an output structure
  • Mapping elements
  • Creating a DI Job
22

SWIFT - Performing a database lookup

  • Creating a database structure
  • Adding a database lookup

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top