ExistBI deliver the following 2-day live instructor-led onsite or virtual Informatica IICS 201 Cloud Data Integration services training course is intended for Developers who wish to integrate data across cloud-based applications. This course allows you to build complex transformations and integrations

Target Audience: Business Analyst, Developer

Pre-requisites: IICS Cloud 101

Delivery Method: Instructor Led Onsite & Virtual Classroom


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

  • Install Secure Agent
  • Perform transformations like Hierarchy Parser, Unconnected Lookups, and so on
  • Utilize advanced features such as Macro Expressions and Dynamic Linking
  • Apply Parameterization and Pushdown Optimization features
  • Utilize the REST web services
  • Work with advanced settings such as PK Chunking, Pre/Post SQL, and SQL Override
  • Use Discovery IQ feature

Official Agenda

Module 1: Introduction to Cloud & Platform Interoperability

  • Informatica Cloud as a SaaS application
  • Informatica Cloud as a platform and understanding its architecture
  • Data Integration and Real Time Integration in Informatica Cloud
  • Features of Informatica Cloud

Module 2: Cloud Mapping Designer

  • Aggregator Transformation Overview
  • Aggregator Transformation – Source and Target
  • Normalizer Transformation
  • Normalized Fields
  • Lookup Transformation
  • Unconnected Lookup

Module 3: Expression Macro and Dynamic Linking

  • Dynamic Linking
  • Flat File Target Time Stamps
  • Macros Expression
  • Types of Expression Macro
  • Performing Dynamic linking

Module 4: Hierarchical Connectivity

  • Web Services and-REST Web Services
  • Parameters of REST Web Service Message
  • REST Connector – Support
  • REST Web Services – Recommendations and Best Practices
  • Web Service Transformation
  • Hierarchical Schemas
  • Hierarchy Parser Transformation
  • Hierarchy Builder Transformation
  • Creating a task to consume RESTful Open Weather Service
  • Using Web Service Transformation in a mapping

Module 5: Informatica Cloud REST API

  • What is a REST API?
  • Informatica Cloud REST API
  • Configuring a Request
  • Synchronization Task using Cloud REST API

Module 6: Performance and Scalability

  • Pushdown Optimization
  • Taxonomy of Data Integration Approaches
  • Combination and comparison of ETL and ELT Approach
  • Pushdown Optimization Guidelines and Best Practices
  • Partitions
  • Types of Partitioning
  • Partitioning Rules and Guidelines
  • Secure Agent Groups with Multiple Agents
  • Mapping Configuration Task with full Pushdown Optimization enabled
  • Multiple partitions to process data concurrently

Module 7: Advanced Properties Settings

  • SQL Overrides in Lookups
  • Lookup SQL Override Attributes
  • PK Chunking
  • Optimal Chunk Size
  • Pre and Post SQL commands
  • Pre/Post SQL Commands in a DSS Task
  • PK Chunking property to run a DSS Task
  • Lookup SQL Override command

Module 8: Discovery IQ

  • Discovery IQ Overview
  • Discovery IQ Features

Module 9: Advanced Parameterization and REST Utilization

  • Parameterization
  • Use case and solution
  • Advanced Parameterization
  • Informatica Cloud REST API utilization
  • Benefits of Informatica cloud REST API and Parameterization
  • Parameterization technique in a mapping

Module 10: Exception Handling

  • Why is Exception Handling required?
  • Exception Classification
  • Default Field Value Setting
  • Row Error Logging
  • Error Handling Settings
  • Fatal Exceptions
  • Reject files or Bad files
  • IICS Mapping to handle Non-Fatal errors

Module 11: Taskflows

  • What is a Taskflow?
  • Taskflow Steps
  • Taskflow Templates
  • Parameters in Taskflows

Module 12: Advanced Administration

  • Custom Roles
  • Asset Level Permissions
  • Rules and Guidelines for Permissions
  • Project or Folder Access Using User Groups
  • Administrative settings for the organization


Print Friendly, PDF & Email