Cloud Data Integration
for Developers

Module 1: Informatica Intelligent Data Management Cloud Overview

• Informatica Intelligent Data Management Cloud (IDMC) as an iPaaS solution
• Using IDMC for ETL
• Informatica Cloud Terminologies
• Informatica Cloud Architecture
• IDMC Interface Walkthrough
• IDMC Services
• Lab: Navigate the IDMC Interface

Module 2: Introduction to the Data Integration Service

• Discuss Data Integration Service
• Pre-requisites to work with the Data Integration Service
• Describe CDI Assets
• Types of Runtime Environments
• Define Connections

Module 3: Basics of Cloud Mapping Designer

• Overview
• Mapping Designer Terminologies
• Mappings
• Mapping Templates
• CLAIRE Recommendations and Copilot
• Mapplets
• Transformations
• Field Rules
• Best Practices Guidelines
• Lab: Build and Execute a Mapping to Load Data

Module 4: Data Integration Transformations

• Joiner Transformation
• Expression Transformation
• Filter Transformation
• Union Transformation
• Sorter Transformation
• Rank Transformation
• Lookup Transformation
• Router Transformation
• Aggregator Transformation
• Lab: Shipping Classification with Joiner, Expression, and Filter Transformations
• Lab: Data Merging and Sorting with Union and Sorter Transformations
• Lab: The Importance of Field Rules
• Lab: Data Enrichment and Optimization Using Lookup and Expression Transformations

Module 5: Macro Introduction and Overview

• Expression Macros
• Vertical Macros
• Horizontal Macros
• Lab: Delta Detection Using the Joiner Transformation

Module 6: Mapplets

• Overview
• Active and Passive mapplet
• Types of IDMC mapplets
• Mapplets Input and Output
• Parameters in mapplets
• PowerCenter mapplet
• Create a mapplet in IDMC
• Mapplet Transformation
• Lab: Enhance Mapping Efficiency with Reusable Mapplets and Conditional Data Routing
• Lab: Summarize Sales Data with Mapplet and Aggregator Transformations

Module 7: Mapping Task

• Overview
• Create and Run a Mapping Task
• Lab: Update Else Insert Logic in a Mapping

Module 8: Parameterization

• What is Parameterization
• Parameterization use case
• Steps to add Parameters to a Mapping
• Create parameters in a Mapping
• Parameter Types
• Use Parameter Files
• In-Out Parameter in Mapplet
• Parameter File Directory
• Parameter Best Practices
• Lab: Flexible Mapping Solutions - Parameterizing Thresholds and Regional Connections
• Lab: Incremental Data Loading with In-Out Parameters

Module 9: Exception Handling

• How to handle errors in Mappings and Mapping Tasks
• Lab: Enhance Data Mappings with Custom Error Handling and Routing

Module 10: Synchronization Task

• Overview
• Definition Step
• Source Step
• Target Step
• Data Filters Step
• Field Mapping Step
• Schedule Step
• Lab: Create a Synchronization Task to Insert Data into Salesforce
• Lab: Create a Synchronization Task to Transform and Load Data Using Expressions, Filtering, and Lookup Techniques
• Lab: Load Data to Salesforce using a Saved Query in a Synchronization Task
• Lab: Use the Upsert Operation in a Synchronization Task to Insert or Update Data in a SQL Server Table

Module 11: Data Transfer Task

• Overview
• Definition Step
• Source Step
• Second Source Step
• Target Step
• Field Mapping Step
• Runtime Options Step
• Lab: Backup Customer and Order Information using a Data Transfer Task

Module 12: Replication Task

• Overview
• Features
• Source and Target Options
• Other Replication Task Options
• Resetting the Target Table
• Generating Non-Unique Index
• Lab: Replicate Salesforce Tables to Flat Files

Module 13: Taskflows

• Overview
• Linear Taskflows
• Taskflow Steps
• Taskflow Templates
• Parameters in Taskflow
• Error Handling in Taskflows
• Lab: Create a Linear Taskflow to run multiple Tasks in Sequence
• Lab: Create a Taskflow with Conditional Logic

Module 14: Web Services

• Overview
• Business Services
• Web Service Transformation
• Lab: Transform Billing Data with Web Services: Number-to-Words Conversion

Module 15: IDMC REST APIs

• REST API Overview
• Informatica Cloud REST API
• List of supported REST API Versions
• Using REST APIs
• Create REST V2 Connector
• Lab: Create a Mapping Using a REST V2 Connector to Retrieve Weather Information
• Lab: Use Informatica CDI to login to the Platform API and Run a Job