Cloud Data Integration
for Developers

Module 1: Informatica Cloud Overview

• Informatica Intelligent Cloud Services (IICS) as an iPaaS solution
• Using IICS for ETL
• Informatica Cloud Terminologies
• Informatica Cloud Architecture
• IICS Interface Walkthrough
• IICS Services
• Lab: Navigating the IICS Interface

Module 2: Introduction to Data Integration Service

• Discuss Data Integration Service
• Pre-requisites to work with Data Integration Service
• Discuss CDI Assets
• Describe CDI Components

Module 3: 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
• Lab: Creating a Salesforce Connection
• Lab: Creating a Synchronization Task
• Lab: Using Filter, Expression, and Lookup in a Synchronization Task
• Lab: Using Saved Query in a Synchronization Task
• Lab: Using Upsert Operation in Synchronization Task

Module 4: Data Transfer Task

• Data Transfer Task Overview
• Data Transfer Task – Definition Step
• Data Transfer Task – Source Step
• Data Transfer Task – Second Source Step
• Data Transfer Task – Target Step
• Data Transfer Task – Field Mapping Step
• Data Transfer Task – Runtime Options Step
• Lab: Creating a Data Transfer Task

Module 5: Basics of Cloud Mapping Designer

• Cloud Mapping Designer Overview
• Types of Mappings
• Mapping Designer Terminologies
• Mapping Templates
• Defining Data Flow Fun Order
• Field Rules
• Best Practices for Creating Mappings

Module 6: IICS Transformations

• Source Transformation
• Target Transformation
• Aggregator Transformation
• Filter Transformation
• Expression Transformation
• Union Transformation
• Rank Transformation
• Sorter Transformation
• Router Transformation
• Lab: Classifying the Product Shipping Details using various Transformations
• Lab: Using Union, Sorter, and Rank Transformations in a Mapping
• Lab: Using Expression Macro in a Mapping
• Lab: Using Vertical Macro in a Mapping
• Lab: Using Horizontal Macro in a Mapping
  

Module 7: Joiner and Lookup Transformations

• Joiner Transformation Overview
• Join Condition
• Join Type - Normal Join, Master outer, Detail Outer, Full Outer
• Lookup Transformation
• Lab: Using Lookup Transformation in a Mapping
• Lab: Merging Current and Previous Data Loads Using Full Outer Join

Module 8: Mapplets

• Mapplets Overview
• Active and Passive mapplet
• Types of IICS mapplets
• Mapplets Input and Output
• Parameters in mapplets
• PowerCenter mapplet
• Create mapplet in IICS
• Mapplet Transformation
• Lab: Using Mapplet Transformation in a Mapping
• Lab: Create Mapplet and Use it in the Existing Mapping
• Lab: Creating a Mapping using Existing Mapplet and Aggregator Transformations

Module 9: Mapping Parameterization

• What is Parameterization
• Parameterization use case
• Steps to add Parameters to a Mapping
• Creating parameters in a mapping
• Parameter Types
• Using parameter files
• In-Out Parameter in Mapplet
• Parameter File Directory
• Parameter Best Practices
• Lab: Performing Complete Parameterization
• Lab: Using In-Out Parameters for Incremental Data Loading

Module 10: Mapping Task

• Mapping Task overview
• Deploy mapping updates
• Field Masking Rules
• Data Masking Transformation
• Simultaneous task runs
• Lab: Creating a Mapping Task to Perform Basic History Tracking and Configure Advanced Settings 

Module 11: 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

Module 12: 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
• Data Masking Transformation
• Lab: Creating a Masking Task
• Lab: Using Data Masking Transformation in a Mapping

Module 13: Taskflows

• Taskflow overview
• Linear Taskflows
• Taskflow Steps
• Taskflow Templates
• Parameters in Taskflow
• Error handling in Taskflows
• Lab: Creating a Linear Taskflow
• Lab: Creating a Taskflow with Conditional Logics

Module 14: IICS REST APIs

• REST API Overview
• Informatica Cloud REST API
• List of supported REST API Versions
• Using REST APIs
• Creating REST V2 Connector
• Web Service Transformation
• Lab: Creating a Mapping Using a REST V2 Connector
• Lab: Using Web Services Transformation in a Mapping
• Lab: Running a Mapping Task Using REST API
• Lab: Monitoring Tasks Using REST API