Cloud Data Integration
for Developers, Advanced 

OnDemand | IDMC Data Integration | Self-Paced | April 2024 Release

Course Overview

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

Objectives

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

  • Use advanced transformations in Cloud Mapping Designer
  • Use Macros in a mapping
  • Create a 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: IDMC Architecture
  • Explain IDMC Architecture
  • New components in IDMC
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: User Defined Functions
  • Explain User Defined Functions
  • Create UDF
  • Edit and Delete UDF
  • Lab: Creating User Defined Functions
Module 4: Transaction Control Transformation
  • Explain Transaction Control Transformation
  • Use of TCT
  • Guidelines for using TCT
  • Lab: Using Transaction Control Transformation in a Mapping
Module 5: Dynamic Schema Handling
  • Explain Schema Change Handling
  • Dynamic Schema Change Handling
  • Limitations of Dynamic Schema Change Handling
  • Schema Handling Options
  • Lab: Handling Dynamic Schema Change in a Mapping
Module 6: Advanced Taskflow Techniques with File Listener
  • Discuss Advanced Taskflow Techniques
  • Explain File Listeners
  • Configure a File Listener
  • Invoke a Taskflow through a File Listener
  • Lab: Passing Values from Mapping to Mapping
  • Lab: Using File Listener as a Step — Version 1
  • Lab: Using File Listener as a Step — Version 2
Module 7: Dynamic Lookup Cache
  • Discuss Dynamic Lookup Cache
  • Field Mapping in Dynamic Lookup Cache
  • Use case of Dynamic Lookup Cache
Module 8: Advanced Parameterization
  • Explain Use of Parameter File
  • Discuss Retention Policy
  • Describe the Aggregation Type
  • Cloud Hosted Parameter File
  • Lab: Using Parameter File in a Mapping
Module 9: 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 10: Exception Handling
  • Types of exceptions
  • User-defined exceptions
  • Non-fatal and Fatal Exceptions
  • Exception handling techniques
  • Bad files or Reject files
  • Lab: Creating a Mapping to Handle Non-fatal Errors
  • Module 11: Normalizer Transformation
  • Explain Normalizer Transformation
  • Describe Normalized Fields
  • Normalizer Filed Mapping
  • Lab: Using Normalizer Transformation in a Mapping to Transform Consolidated Data
Module 12: Hierarchical Connectivity
  • Hierarchical Schemas
  • Hierarchy Parser Transformation
  • Hierarchy Builder Transformation
  • Lab: Using Hierarchy Parser and Hierarchy Builder Transformations
Module 13: 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: Creating an Intelligent Structure Model
  • Lab: Using Structure Parser Transformation in a Mapping
Module 14: SQL ELT Optimization
  • SQL ELT optimization Overview
  • Types of SQL ELT optimization
  • SQL ELT optimization in Advanced mode
  • Lab: Performing SQL ELT Optimization in IICS
Module 15: Mapping Partitioning
  • Partitions Overview
  • Types of Partitions
  • Partitioning Rules and Guidelines
  • Lab: Performing Partitioning
Appendix: Advanced Integration
  • Introduction
  • Advantages of Advanced Integration
  • Advanced Serverless
Enroll Now

Back to Course Overview