IICS: Cloud Data Integration Services

onDemand | Cloud / iPaas | Self-Paced | Release 37

IICS: Cloud Data Integration Services

Course Overview

This course is applicable to version R37. Learn the fundamentals of Informatica Intelligent Cloud Services (IICS) including the architecture and data integration features, synchronization tasks, cloud mapping designer, masking tasks and replication tasks. This course enables you to operate and manage user security, secure agents, and monitor tasks and resources in IICS.

Objectives

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

Describe Informatica Cloud Architecture
Install the secure agent and create connections
Create Synchronization task
Data Transfer Task
Use Cloud Mapping Designer to create Mappings and Mapping Tasks
Create a Replication task
Create a Masking task
Create a Mass Ingestion task
Create Taskflows
Use IICS REST web services for data integration
Use Intelligent Structure Model to parse data
Handle exceptions
Use advanced data integration features to optimize performance of jobs
Automate and monitor tasks
Configure advanced administration settings in IICS
Distinguish users and groups
Configure custom roles in IICS
Asset Management

Target Audience

Administrator
Developer
Operator

Prerequisites

None

Agenda
Module 1: Informatica Cloud Overview Informatica Intelligent Cloud Services (IICS) as an iPaaS solution Informatica Cloud Terminologies Informatica Cloud Architecture CDI Assets CDI Components Lab: Navigating the IICS interface Module 2: Runtime Environments and Connections Runtime Environments Secure Agent Architecture Secure Agent Status Elastic Server Secure Agent Services IICS Log Files Connections Connection Types Creating Connections Lab: Installing IICS Secure Agent Lab: Creating a Salesforce connection Lab: Creating a Flat File connection Lab: Creating an Oracle connection Module 3: Synchronization and Data Transfer 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 Data Transfer Task Activity Monitor Lab: Creating a Synchronization Task Lab: Using Filter, Expression and Lookup in a Synchronization Task Lab: Creating a Data Transfer Task Module 4: Cloud Mapping Designer Cloud Mapping Designer Overview Mapping Designer Terminologies CLAIRE Transformation Recommendations Mapping Data Preview Customizing Mapping Preview Field Rules Best Practices for Creating Mappings Data flow run order Mapping Task Dynamic Schema Change Deploy mapping updates Demo: Creating a simple Mapping Demo: Creating a Mapping Task Module 5: Cloud Mapping Designer - Transformations Source Transformation Target Transformation Filter Transformation Joiner Transformation Expression Transformation Lookup Transformation Union Transformation Mapplets SQL Transformation Aggregator Transformation Normalizer Transformation Rank Transformation Data Masking Transformation Java Transformation Lab: Using Query in a Mapping Lab: Using Normalizer, Aggregator, and Rank transformations in a mapping Lab: Using Unconnected Lookup transformation in a mapping Lab: Using Mapplet transformation in a mapping Module 6: Mapping Parameters Parameterization use cases Adding Parameters to a Mapping Creating parameters Parameter Types Using parameter files In-Out Parameter in Mapplet Parameter File Directory Parameter Best Practices Lab: Performing Complete Parameterization Lab: Using Parameter File in a Mapping task Lab: Using In-Out parameters for incremental data loading Module 7: Expression Macro and Dynamic Linking Expression Macro Dynamic Linking Lab: Using Expression Macro in a mapping Lab: Using Dynamic Linking in a mapping Module 8: 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 Appendix: Replicating Data to a Flat file Creating a replication task Module 9: 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 Lab: Create Masking task	Module 10: Mass Ingestion Task Mass Ingestion Task Overview Functionalities Configuring a Mass Ingestion Task File Ingestion Task Database Ingestion Task Streaming Ingestion Task Lab: Creating a Streaming Ingestion Task Module 11: Taskflows Taskflow overview Linear Taskflows File Listener Enhancements Taskflow Steps Taskflow Templates Parameters in Taskflow Using REST APIs Invoke a Taskflow through a File Listener Lab: Passing in-out parameters in a Taskflow Lab: Invoking a Taskflow through a File Listener Demo: Creating a Liner Taskflow Module 12: Hierarchical Connectivity Web Service transformation REST V2 Connector Hierarchical Schemas Hierarchy Parser Transformation Hierarchy Builder Transformation Lab: Creating a mapping using a REST V2 connector Lab: Using Web Services transformation in a mapping Lab: Using Hierarchy Parser and Hierarchy Builder Transformation Module 13: Intelligent Structure Model Intelligent Structure Model Intelligent Structure Discovery Process Intelligent Structure Example Refining a Discovered Structure Editing an Intelligent Structure Model Intelligent structure models based on an XSD file Using intelligent structure models in Structure Parser transformation Lab: Creating an Intelligent Structure Model Lab: Using Structure Parser transformation in a mapping Module 14: Advanced Task Settings and Performance Tuning Primary Key Chunking Lookup SQL Override Partitions Overview Types of Partitions Partitioning Rules and Guidelines Pushdown optimization overview Types of pushdown optimization Pushdown optimization user-defined parameters Secure agent groups Shared secure agent groups DTM performance properties Module 15: Exception Handling Types of exceptions User-defined exceptions Non-fatal exceptions Default Field Value Setting Row Error Logging Error handling settings Fatal exceptions Bad files or Reject files Lab: Creating a mapping to handle non-fatal errors Module 16: Administration Licenses Administrator Service User Roles (System-defined Roles and Custom Roles) Creating a User User Groups User Statistics Permissions Object-Level Permissions Organization Hierarchy Sub-Organization Importing and Exporting Assets Asset Dependency Add-on Bundles Lab: Creating a Sub-Organization and configure Administrative Settings Demo: Creating Sub-Organization and Export/Import Assets Module 17: Automating and Monitoring Tasks Schedules Schedule Repeat Frequency Schedule Blackout Period Schedule Export Monitoring tasks Email Notifications Event Monitoring Lab: Creating a schedule Module 18: IICS APIs REST API overview Informatica Cloud REST API REST API Versions Request Header and Request Body configuration Return Lists Demo: RunAJob Utility Lab: Running a Mapping task using REST API Additional Exercise: Appendix 3: Performing Org Cleanup


Back to Course Overview

QUESTIONS?

Work Email:

First Name:

Last Name:

Company:

Phone:

Country:

Yes, I would like to receive communications from Informatica about products, solutions and events.

Lead Source:

Lead Source Campaign:

Employee Range:

Revenue Range: