This four-day training course is designed to introduce the student to Informatica B2B Data Transformation and those who want to develop and implement Data Transformations, as well as learn methodologies and best practices for parsing, serialization, and mapping tasks. Through lectures and hands on exercises, this class will cover the major functionalities of the PowerCenter Unstructured Data Option.

Course Agenda

Module 1: Introduction to Data Transformation

  • Topics covered include: features, supported APIs, and supported data formats

Module 2: XML and XSD Basics

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

Module 3: Basic Parsing

  • Explain the concept of parsing by example
  • Describe basic anchors in Data Transformation

Module 4: Parsing

  • Create a new parser
  • Describe the following concepts: Ports and formats, CustomFormat and delimiters, Format preprocessors, Data holders, Anchors
  • Explain the uses of user- and system-defined variables
  • Adjust search criteria with scope and phase
  • Search for anchors with a parser

Module 5: Document Preprocessors

  • Describe the various types of document preprocessors: Excel, PDF, and PowerPoint, XML, External Java and C++
  • Explain pattern matching and basic expressions
  • Describe character classes, pattern representation, repeating characters, and line anchors
  • Understand OR condition, grouping, and greedy searching
  • Explain RegularExpresssion syntax in Data Transformation and also in PDF parsing

Module 6: Overview of Data Transformation

  • Explain Studio components and perspectives
  • Describe the architecture and services

Module 7: Conditions

  • Compare serializers, mappings, and variables
  • Use SetValue and EnsureCondition Actions

Module 8: Transformers and Actions

  • Explain default and commonly used transformers
  • Compare actions and transformers
  • Explain commonly used actions
  • Describe data manipulation functions

Module 9: Mappers

  • Describe mappers and locators
  • Create a mapper
  • Understand the following concepts: Map anchor, Alternative mappings, Embedded mapper, Group mapping

Module 10: Positional Parsing

  • Explain the positional delimiters component
  • Describe positional serializing

Module 11: Locators, Keys, and Indexing

  • Describe composite keys and the restrictions on keys
  • Explain locator and LocatorByKey and their uses in a mapping
  • Explain LocatorByOccurrence
  • Discuss the influence of component source and target properties on the locators

Module 12: Advanced Anchors

  • Describe an enclosed group and delimited sections
  • Explain EmbeddedParser and schema connections

Module 13: Embedded Parsers

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

Module 14: Serializers

  • Create a serializer
  • Describe commonly used, string, and content serializers
  • Explain how serializers utilize locator property

Module 15: Streamers

  • Describe text and XML streamers
  • Process large documents

Module 16: Validators, Notification, and Failure Handling

  • Describe the components of validators
  • Explain notifications and NotificationHandlers
  • Explain failure handling and optional property
  • Write failure messages to the user log

Module 17: PowerCenter Integration – UDT

  • Explain EDI parsing in PowerCenter
  • Describe input and output hierarchy
  • Explain dynamic service name

Module 18: Data Transformation Libraries

  • Create and test the library project
  • Utilize the library customization tool
  • Debug the library customization project

Module 19: Data Transformation Features

  • Describe the Informatica Developer unified development platform
  • Explain the data processor and XMap