Print Friendly and PDF

Cloud Data Integration
for Developers

onDemand | IDMC Data Integration | Self-Paced | Release 42

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 Release 42. 

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
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: Create a Mapping Task 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) 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