Cloud Data Integration
for Developers

onDemand | IDMC Data Integration | Self-Paced | July 2024 Release

Course Overview

Learn the fundamentals of Informatica Intelligent Cloud Services (IICS) including the architecture and data integration features, synchronization tasks, cloud mapping designer, DI mappings, mapplets, mapping parameters, masking tasks, and replication tasks.
This course is applicable to July 2024 Release.

Important note regarding this onDemand course: Many students will need their personal laptop/PC to set up the lab environment and perform lab exercises. Laptops provided by your employer may not allow downloading external tools. To execute labs in full, students need to download and install the following tools. See Agenda below to view more details. If you are unable to complete this training due to these requirements, please consider Live Training.

Informatica Cloud Secure Agent
Microsoft SQL Server
Postman

Objectives

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

Describe Informatica Cloud Architecture
Create Synchronization task
Create Data Transfer task
Use Cloud Mapping Designer to create mappings
Use Lookup and Joiner transformations
Create Mapplets and work with them
Create parameters in a mapping
Discuss Mapping tasks
Create a Replication task
Create a Masking task
Create Taskflows
Use IICS REST web services for DI

Target Audience

Developer

To execute all labs within this course, students should download and install the following:

Informatica Cloud Secure Agent:
The Informatica Cloud Secure Agent is required to create connections to connect to various data sources with IICS.
Microsoft SQL:
Some of the course lab exercises are dependent on the Microsoft SQL database. You must install and configure Microsoft SQL database to perform these labs. If you do not have Microsoft SQL installed on your system, you can skip the labs that are Microsoft SQL database dependent and continue with the rest of the course and lab exercises.

Postman:
The postman application is required to perform REST APIs call and execute IICS task using API.

Steps required to set up the lab environment are provided in the Getting Started lab guides for the course. Students must perform the Getting Started labs before executing the course lab exercises.

Agenda

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
Lab: Installing Secure Agent
Lab: Creating Flat File Connections

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 SQL Server Connections
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

Parameterization and 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

Enroll Now

Back to Course Overview

Power User

Axon for Community Users (Instructor Led or onDemand)

Axon Content Curation (Instructor Led)

Axon for Power Users (Instructor Led)

Axon Data Governance (Professional Certification)

Axon Data Governance (Professional Certification) Some more content to make this bigger asdf asdf asdf

Informatica offers programs to extend learning in convenient and economic packages. Programs include self-paced subscriptions as well as bundled instructor led training and certifications. Each program is curated around a specific skillset to enable customer success.

365University Data Governance Annual Subscription

Informatica MasterPass Education Subscription

Informatica Learning Library

Data Governance & Privacy Journey Master

View Full Course Offerings

Need More Information?

Frequently Asked Questions

Training Terms & Conditions →

Cloud Data Integration for Developers