Print Friendly and PDF

Cloud Data Integration
for Developers, Advanced 

Instructor Led | IDMC Data Integration | 3 days | Release 42

Course Overview

Explore the advanced functionalities of Informatica Intelligent Cloud Services such as using expression macros, dynamic mapping task, file listeners, handling dynamic schema change and errors, performing structure discovery, SQL ELT optimization, partitioning, and using advanced transformation in cloud mapping designers.
This course is applicable to Release 42.

Objectives

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

  • Use advanced transformations in Cloud Mapping Designer
  • Use Macros in a mapping
  • Create Dynamic Mapping task
  • Handle Dynamic schema change
  • Use file listener for task automation
  • Use Hierarchy builder and parser transformations
  • Use Intelligent Structure Discovery
  • Use Unconnected Lookup transformation in a mapping
  • Perform SQL ELT optimization in a mapping
  • Perform various types of Partitioning
  • Perform error handling in IICS
  • Discuss the performance tuning in IICS

Target Audience

  • Developer

Prerequisites

Agenda
Module 1: IICS Transformations
  • Normalizer Transformation
  • SQL Transformation
  • Transaction Control Transformation
  • Sequence Generator Transformation
  • Velocity Transformation
  • Schema Change Handling
  • Lab: Using Transaction Control Transformation in a Mapping
  • Lab: Using Normalizer Transformation in a Mapping to Transform Consolidated Data
  • Lab: Create Expression Macro in a Mapping
  • Lab: Using Vertical Macro in a Mapping
  • Lab: Using Horizontal Macro in a Mapping
  • Lab: Create Dynamic Schema Change Handling
Module 2: Dynamic Mapping Task
  • Overview of Dynamic Mapping Task
  • Parameters in Dynamic Mapping Task
  • Jobs and Job Groups
  • Configuring a Dynamic Mapping Task
  • Lab: Create a Dynamic Mapping Task
Module 3: File Listeners
  • File Listeners overview
  • Using File Listeners
  • Steps to configure a File listener
  • Invoke a Taskflow through a File Listener
  • Lab: Passing In-out Parameters in a Taskflow
  • Lab: File Listener as a Step — Version 1
  • Lab: File Listener as a Step — Version 2
  • Lab: Invoking a Taskflow through a File Listener
Module 4: Hierarchical Connectivity
  • Hierarchical Schemas
  • Hierarchy Parser Transformation
  • Hierarchy Builder Transformation
  • Lab: Using Hierarchy Parser and Hierarchy Builder Transformation
Module 5: Intelligent Structure Model
  • Intelligent Structure Model
  • Intelligent Structure Discovery Process
  • Intelligent Structure Example
  • Refining a Discovered Structure
  • Intelligent structure models based on MS Word file
  • Using intelligent structure models in Structure Parser transformation
  • Lab: Using Structure Parser Transformation in a Mapping
Module 6: Mass Ingestion Task
  • Mass Ingestion Task Overview
  • Configuring a Mass Ingestion Task
  • Application Ingestion Task
  • File Ingestion Task
  • Database Ingestion Task
  • Streaming Ingestion Task
  • Lab: Creating a Streaming Ingestion Task
  • Lab: Creating a File Ingestion Task
Module 7: Exception Handling
  • Types of exceptions
  • User-defined exceptions
  • Non-fatal exceptions
  • Default Field Value Setting
  • Row Error Logging
  • Performing recovery in IICS
  • Error handling settings
  • Fatal exceptions
  • Bad files or Reject files
  • Lab: Creating a Mapping to Handle Non-fatal Errors
Module 8: Performance Tuning/Advanced Task Settings
  • Partitions Overview
  • Types of Partitions
  • Partitioning Rules and Guidelines
  • SQL ELT optimization overview
  • Types of SQL ELT optimization
  • SQL ELT optimization user-defined parameters
  • DTM performance properties
  • Unconnected Lookup
  • Lab: Performing SQL ELT Optimization in IICS
  • Lab: Performing Partitioning
  • Lab: Creating a Mapping Using Unconnected Lookup Transformation
Appendix: Advanced Integration
  • Introduction
  • Advantages of Advanced Integration
  • Advanced Serverless
Enroll Now

Back to Course Overview