Print Friendly and PDF

Cloud Data Integration
for Developers

Instructor Led | IDMC Data Integration | 4 days | 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.

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

Prerequisites

  • None
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
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
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: 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