Course content:

IICS – Cloud Data Integration (CDI)

1: Informatica Overview

• Informatica Intelligent Cloud Services (IICS) as an iPaaS solution

• Informatica Cloud Terminologies

• Informatica Cloud Architecture

• CDI Assets

• CDI Components (Tool Overview)

• Lab: Navigating the IICS interface

2: Runtime Environments and Connections

• Runtime Environments

• Secure Agent Architecture

• IICS Log Files

• Connections

• Connection Types

• Creating Connections

• Lab: Creating a Salesforce connection

• Lab: Creating a Flat File connection

• Lab: Creating an Oracle connection

3: Cloud Mapping Designer – Basic Transformations

• Cloud Mapping Designer Overview

• Mapping Designer Terminologies

• Source Transformation

• Target Transformation

• Filter Transformation

• Joiner Transformation

• Expression Transformation

• Lookup Transformation

• Field Rules

• Best Practices for Creating Mappings

• Lab: Creating a mapping using basic transformations

4:  Synchronization Task

• Synchronization Task Overview

• Synchronization Task – Definition Step

• Synchronization Task – Source Step

• Synchronization Task – Target Step

• Synchronization Task – Data Filters Step

• Synchronization Task – Field Mapping Step

• Synchronization Task – Schedule Step

• Activity Monitor

• Lab: Creating a Synchronization Task

5: Replication Task

• Replication Task Overview

• Replication Task Features

• Replication Task: Source and Target Options

• Other Replication Task Options

• Resetting the Target Table

• Generating Non-Unique Index

• Lab: Replicating Data to a Flat File

6: Masking Task

• Masking Task Overview

• Masking Task: Source and Target Options

• Data Subset: Row Limits and Data Filters

• Field Masking Rules

• Masking Rule Types

• Refresh Masking Task metadata

• Reset a Masking Task

• Masking Best Practices

• Lab: Creating a Masking Task

7: Advanced Transformations and Mapping Tasks

• Aggregator Transformation

• Normalizer Transformation

• Union Transformation

• Lookup Transformation

• Rank Transformation

• Sequence Generator Transformation

• Rule Specification Transformation

• Mapping Task

• Lab: Using Normalizer, Aggregator, and Rank transformations in a mapping

• Lab: Creating a mapping using Unconnected Lookup Transformation

• Lab: Creating a Mapping Task

8: Mapping Parameters

• Parameterization use cases

• Adding Parameters to a Mapping

• Creating parameters

• Parameter Types

• Using parameter files

• Parameter Best Practices

• Lab: Using Parameter File in a Mapping task

• Lab: Using In-Out parameters for incremental data loading

9: Dynamic Linking

• Dynamic Linking

• Lab: Using Dynamic Linking in a mapping

10: Taskflows

• Taskflow overview

• Linear Taskflows

• Taskflow Steps

• Taskflow Templates

• Using REST APIs

• Lab: Creating a Parallel Taskflow

• Lab: Passing in-out parameters in a Taskflow

11: Intelligent Structure Model

• Intelligent Structure Model

• Intelligent Structure Discovery Process

• Intelligent Structure Example

• Refining a Discovered Structure

• Editing an Intelligent Structure Model

• Using intelligent structure models in Structure Parser transformation

• Lab: Creating an Intelligent Structure Model

• Lab: Using Structure Parser transformation in a mapping

12: Hierarchical Connectivity

• Web Service transformation

• REST V2 Connector

• Hierarchical Schemas

• Hierarchy Parser Transformation

• Hierarchy Builder Transformation

• Lab: Creating a mapping using a REST V2 connector

• Lab: Using Web Services transformation in a mapping

• Lab: Creating a mapping using Hierarchy Parser Transformation

• Lab: Creating a mapping using Hierarchy Builder Transformation