Informatica Cloud Data Integration Content

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

Module 1: Informatica Cloud Overview

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

 Module 2: Introduction to Data Integration Service

  • IICS trail Account Create and Activation 
  • Install and Configure Secure Agent
  • Services enablement on Secure Agent
  • 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 Oracle 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/IDMC
  • 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

Comments

Post a Comment