Exist Management LLC (ExistBI) is an Authorized Informatica Training Partner. Our trainers are certified, enthusiastic and extremely experienced. We deliver classic or fit for purpose Informatica B2B training curriculums in your office or via instructor-led virtual classroom to meet the needs of your organization.

This 4-day Informatica B2B course is an introduction to Informatica’s B2B Data Transformation designed for those who want to develop and implement data transformation services as well as learn best practices for parsing, serializing, and mapping tasks. This course is applicable to software version 10.1.

Objectives:

After successfully completing this course, students should be able to:

  • Discuss the key concepts of the B2B Data Transformation
  • Utilize parsing techniques
  • Move information from an XML structure to an output format
  • Perform XML to XML transformation with mappers
  • Discuss various preprocessors and their uses
  • Describe locators, keys, and indexing and their uses
  • Explain concepts of logic implementation via conditions, specification-driven transformation, streamers to process large documents, validators, notification, and failure handling
  • Discuss PowerCenter integration via the Data Processor transformation, the usage of Data Transformation services in B2B Data Exchange and the usage of pre-built libraries in Data Transformation

Course Duration

  • Four-days of instructor led training
  • 60% lecture, 40% hands-on

Target Audience

  • Administrators
  • Consultants

Agenda

Module 1: Introduction to Data Transformation

  • Features, supported APIs, and supported data formats

Module 2: Overview of Data Transformation

  • Developer/Data Processor components and perspectives
  • Architecture and services

Module 3: XML and XSD Basics

  • Overview of both XML and XSD
  • Compare the XSD and Data Transformation syntax

Module 4: Basic Parsing

  • Parsing by example concept
  • Basic anchors in Data Transformation

Module 5: Parsing

  • Create a new parser
  • Parsing Concepts:
  • CustomFormat and delimiters
  • Uses of user- and system-defined variables
  • Search criteria with scope and phase
  • Anchors with a parser

Module 6: Transformers and Actions

  • Default and commonly used transformers
  • Actions and transformers
  • Commonly used actions
  • Data manipulation functions

Module 7: Serializers

  • Create a serializer
  • Commonly used, string, and content serializers
  • How serializers utilize locator property

Module 8: Regular Expressions

  • Pattern matching and basic expressions
  • Character classes, pattern representation, repeating characters, and line anchors
  • Understand OR condition, grouping, and greedy searching
  • RegularExpresssion syntax in Data Transformation and also in PDF parsing

Module 9: Conditions

  • Serializers, mappings, and variables
  • SetValue and EnsureCondition Actions

Module 10: Positional Parsing

  • Positional delimiters component
  • Positional serializing

Module 11: Mappers

  • Mappers and locators
  • Create a mapper
  • Mapper concepts

Module 12: Locators, Keys, and Indexing

  • Composite keys and the restrictions on keys
  • Locator and LocatorByKey and their uses in a mapping
  • LocatorByOccurrence
  • The influence of component source and target properties on the locators

Module 13: Advanced Anchors

  • Enclosed group and delimited sections
  • EmbeddedParser and schema connections

Module 14: Embedded Parsers

  • Process segments of source with embedded parsers
  • EmbeddedParsers and RunParsers

Module 15: Streamers

  • Text and XML streamers
  • Processing of large documents

Module 16: PowerCenter Integration – UDT

  • EDI parsing in PowerCenter
  • Input and output hierarchy
  • Dynamic service name

Module 17: Data Transformation 10.x Features

  • XMap
  • Data Processor Wizards
  • JSON document using the DP Wizard
Print Friendly, PDF & Email