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
Runtime Environments and Connections
- Runtime Environments
- Secure Agent Architecture
- IICS Log Files
- Connections
- Connection Types
- Creating Connections
- Lab: Creating a Salesforce connection
- Lab: Creating a Flat File connection
- Lab: Creating an Oracle connection
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
- Activity Monitor
- Lab: Creating a Synchronization Task, Data Task, Replication task, Power Center Task
- Lab: Using Filter, Expression and Lookup in a Synchronization Task
- Lab: Using Pre and Post SQL commands in a Synchronization Task
Cloud Mapping Designer – Basic Transformations
- Cloud Mapping Designer Overview
- CLAIRE Transformation Recommendations
- Mapping Designer Terminologies
- Source Transformation - Advanced Properties including pre/post sql, Pre/Post processing commands
- Target Transformation with advanced Properties that include/Insert/Update/Upsert operations
- Filter Transformation
- Joiner Transformation
- Expression Transformation
- Lookup Transformation
- Field Rules
- Best Practices for Creating Mappings
- Lab: Creating a mapping using basic transformations
Advanced Transformations and Mapping Tasks
- Aggregator Transformation
- Normalizer Transformation
- SQL Transformation
- Parser Transformation
- Union Transformation
- Lookup Transformation
- Rank Transformation
- Sequence Generator Transformation
- Data Masking Transformation
- Mapping Task
- Lab: Using Normalizer, Aggregator, and Rank transformations in a mapping
- Lab: Creating a Mapping Task
- Lab: Creating a mapping using Unconnected Lookup Transformation
- Lab: Creating a mapping using SQL Transformation
Mapping Parameters
- Parameterization use cases
- Adding Parameters to a Mapping
- Creating parameters
- Parameter Types
- Using parameter files
- Parameter Best Practices
- Lab: Performing Complete Parameterization
- Lab: Using Parameter File in a Mapping task
- Lab: Using In-Out parameters for incremental data loading
Expression Macro and Dynamic Linking
- Expression Macro
- Dynamic Linking
- Lab: Using Expression Macro in a mapping
- Lab: Using Dynamic Linking in a mapping
Task flows
- Task flow overview
- Linear Task flows
- Task flow Templates
- Task flows with Parallel path, Decision steps
- Invoke a Task flow through a File Listener
- Lab: Creating a Parallel Task flow
- Lab: Passing in-out parameters in a Task flow
- Lab: Invoking a Task flow through a File Listener
Hierarchical Connectivity
- Web Service transformation
- REST V2 Connector
- Hierarchical Schemas and Intelligent Structure Model
- Hierarchy Parser Transformation
- Hierarchy Builder Transformation
- Lab: Creating a mapping using a REST V2 connector
- Lab: Using Web Services transformation in a mapping
- Lab: Creating a mapping using Hierarchy Parser Transformation
- Lab: Creating a mapping using Hierarchy Builder Transformation
Rest API Login/Activity/Invoking a mapping task through Postman
- Rest API Introduction
- Rest API Login from Postman
- Rest API Activity Logs from Postman
- Rest API Invoking mapping task from Postman
- Rest API Invoking task flow from postman
Understanding the Basics Process Designer
- Create a Basic Process to Display User Input
Working with Assets
- Create Process Objecs
- Create a Service Connector
- Create App Connection using Service Connector
- Create JDBC Connection
- Create Customer and Order Details
- Create File Connection
- Create SalesForce Connection
Webservice to Process
- Invoke a Synchronous Web Service Call
- Invoke a ASynchronous Web Service Call
Fault Handling
- Handle subprocess Failure
- Handle Credential Failures
Guides Designer
- Create Simple Guide
- Create guide using guides designer
CAI & CDI Inegration
- Creating a Flat File connection
- Create basic mapping and Mapping task
- Inove a mapping in CAI