This 4-day Informatica IICS training takes you through Informatica Intelligent Cloud Services (IICS) including the architecture and data integration features, data synchronization, cloud mapping designer, data masking and data replication. This course enables you to integrate data between cloud-based applications and on-premises systems, and develop and implement integration solutions using Cloud Mapping Designer by leveraging advanced transformation and connectivity features of IICS.

Official Agenda

1: Informatica Cloud Overview

  • Informatica Cloud
  • Object Synchronization
  • Process Synchronization
  • Data Replication and Archiving
  • Informatica Cloud Applications
  • Informatica Cloud – Key Terms

2: Cloud Secure Agent & Architecture

  • Informatica Cloud Architecture
  • Informatica Cloud Secure Agent
  • Informatica Secure Agent Architecture
  • Agent Log File
  • Running Agent as Local/Network User

3: Creating Connections

  • Connection Properties
  • Connection types
  • Configuring a connection
  • Creating a Salesforce.com Connection
  • Creating a Flat File Connection

4: Data Synchronization Application

  • Data Synchronization application
  • Data Synchronization Operations
  • Field Information
  • Activity Logs
  • Log file types

5: Relationships and Integration

  • Purpose of external ID
  • External ID fields in Salesforce.com
  • Foreign Keys
  • Salesforce ID
  • Data Synchronization Operations – IDs

6: Qualifying & Transforming Source Data

  • Data Filter
  • Simple and Advanced Data Filter
  • System Variables in a Data Filter
  • Incremental Processing
  • Field Expression

7: Advanced Source Options

  • Multiple Object Source Type
  • Salesforce Objects – Options
  • Salesforce Data Model and ERDs
  • Saved Queries

8: Field Lookups

  • Lookup Overview
  • Configuring a Lookup
  • Lookup Best Practices

9: Data Replication Application

  • Data Replication App Overview
  • Data Replication Features and Benefits
  • Data Replication Source and Target Options
  • Other Data Replication Task Options
  • Resetting the Target Table
  • Non-Unique Index

10: Automating and Monitoring Tasks

  • Schedules
  • Schedule Repeat Frequency
  • Repeat Frequency Options
  • Schedule Blackout Period
  • Task Flow
  • Email Notifications
  • Informatica Cloud Mobile App

11: Cloud Mapping Designer – Part I

  • Cloud Mapping Designer use cases
  • Mapping Lifecycle
  • Transformations in Cloud Mapping Designer
  • Mapping Validation
  • Creating a Simple Mapping using a Source, Filter, and Multiple Targets

12: Cloud Mapping Designer – Part II

  • Joiner, Expression, and Lookup transformations
  • Field Rules: Renaming Fields, Selection Criteria
  • Creating a Mapping using the Lookup and Expression Transformations

13: Mapping Task and Mapping Parameters

  • Mapping Task
  • Parameterization use cases
  • Adding Parameters to a Mapping
  • Parameter Types
  • Parameter Panel and Best Practices
  • Mapping Updates and Deployment
  • Creating, testing, and running a Mapping Task

14: Advanced Task Options

  • Pre and Post-Processing Commands
  • Operating System Commands
  • Parameter File
  • Setting Up a Parameter File

15: Advanced Salesforce Options

  • Salesforce target batch size
  • Salesforce bulk API
  • Salesforce outbound messaging to trigger a synchronization task

16: Data Masking Application

  • Data Masking Service
  • Data Subset: Row Limits and Data Filters
  • Building, testing, and running a Data Masking task

17: Administration

  • User Roles
  • User Groups
  • Object level permissions
  • Organization hierarchy
  • Migrating Assets

18: Linear Taskflow

  • Linear Taskflow Overview
  • Tasks included in a Linear Taskflow
  • Properties of a Linear Taskflow
  • Scheduling a Taskflow

19: Mass Ingestion Task

  • Mass Ingestion Task Overview
  • Functionalities
  • Configure Mass Ingestion Task

20: Introduction to Cloud & Platform Interoperability

  • Informatica Cloud as a SaaS application
  • Informatica Cloud as a platform and understanding its architecture
  • Data Integration and Real Time Integration in Informatica Cloud
  • Features of Informatica Cloud

21: Cloud Mapping Designer

  • Aggregator Transformation Overview
  • Aggregator Transformation – Source and Target
  • Normalizer Transformation
  • Normalized Fields
  • Lookup Transformation
  • Unconnected Lookup

22: Expression Macro and Dynamic Linking

  • Dynamic Linking
  • Flat File Target Time Stamps
  • Macros Expression
  • Types of Expression Macro
  • Performing Dynamic linking

23: Hierarchical Connectivity

  • Web Services and-REST Web Services
  • Parameters of REST Web Service Message
  • REST Connector – Support
  • REST Web Services – Recommendations and Best Practices
  • Web Service Transformation
  • Hierarchical Schemas
  • Hierarchy Parser Transformation
  • Hierarchy Builder Transformation
  • Creating a task to consume RESTful Open Weather Service
  • Using Web Service Transformation in a mapping

24: Informatica Cloud REST API

  • What is a REST API?
  • Informatica Cloud REST API
  • Configuring a Request
  • Synchronization Task using Cloud REST API

25: Performance and Scalability

  • Pushdown Optimization
  • Taxonomy of Data Integration Approaches
  • Combination and comparison of ETL and ELT Approach
  • Pushdown Optimization Guidelines and Best Practices
  • Partitions
  • Types of Partitioning
  • Partitioning Rules and Guidelines
  • Secure Agent Groups with Multiple Agents
  • Mapping Configuration Task with full Pushdown Optimization enabled
  • Multiple partitions to process data concurrently

26: Advanced Properties Settings

  • SQL Overrides in Lookups
  • Lookup SQL Override Attributes
  • PK Chunking
  • Optimal Chunk Size
  • Pre and Post SQL commands
  • Pre/Post SQL Commands in a DSS Task
  • PK Chunking property to run a DSS Task
  • Lookup SQL Override command

27: Discovery IQ

  • Discovery IQ Overview
  • Discovery IQ Features

28: Advanced Parameterization and REST Utilization

  • Parameterization
  • Use case and solution
  • Advanced Parameterization
  • Informatica Cloud REST API utilization
  • Benefits of Informatica cloud REST API and Parameterization
  • Parameterization technique in a mapping

29: Exception Handling

  • Why is Exception Handling required?
  • Exception Classification
  • Default Field Value Setting
  • Row Error Logging
  • Error Handling Settings
  • Fatal Exceptions
  • Reject files or Bad files
  • IICS Mapping to handle Non-Fatal errors

30: Taskflows

  • What is a Taskflow?
  • Taskflow Steps
  • Taskflow Templates
  • Parameters in Taskflows

31: Advanced Administration

  • Custom Roles
  • Asset Level Permissions
  • Rules and Guidelines for Permissions
  • Project or Folder Access Using User Groups
  • Administrative settings for the organization
Print Friendly, PDF & Email
Summary
Review Date
Reviewed Item
Informatica IICS Training
Author Rating
51star1star1star1star1star