Course summary
At A.B Link, we believe hands-on is the best way to become familiar with a new tool. We designed this course to provide ability to work with parser/mapper/serializer to implement different data transformation requirements, using Informatica tools. This course is introduction to Informatica Data Transformation with heavy focus on hands-on exercising and using best practices.
Course Agenda breakdown
Topic 1 :
Introduction to Informatica B2B Data Transformation
- Overview of Informatica’s tools capabilities and Data Transformation concepts
- Introduction to Developer tool and Data Processor.
- XML and XSD overview.
Topic 2
Basic components of Data Processor
- Parser
- Mapper
- Serializer
- Xmap
Topic 3
Creating Data Processor with Wizard
- Input and Output formats overview
- JSON to Relational
- Relational to XML
Topic 4
Parser
- UI overview
- Create new parser
- How to import parser
- How to export parser
Topic 5
Parser anchor-Marker
- Marker text
- Marker offset
- Marker pattern
Topic 6
Parser anchor-Content
- Content attributes
- Transformers
Topic 7
Parser anchor-Repeating group
- Separator
- Repeating group attributes
Topic 8
Parser – implementing various logic and requirements
- Conditions
- Error handling
- Optional property usage
Topic 9
Mapper
- Create a mapper
- Locators
Topic 10
Serializer
- Create a serializer
- String and content serialize
Topic 11
Streamer
- Create streamer
- How to handle large files
Topic 12
Power center – DT integration
- UDT transformation in PwC
- UDT Relational Hierarchy
