This course is applicable to version R38. 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.
Course content
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
2: Runtime Environments and Connections
- Runtime Environments
- Secure Agent Architecture
- Secure Agent Status
- Configuring Firewall for Secure Agent
- 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
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 tasks Overview
- Data transfer tasks – Source and Target
- Activity Monitor
- Lab: Creating a Synchronization Task
- Lab: Using Filter, Expression and Lookup in a Synchronization Task
4: Cloud Mapping Designer
- Cloud Mapping Designer Overview
- Mapping Designer Terminologies
- CLAIRE Transformation Recommendations
- Copying Transformation
- 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
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
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
7: Expression Macro and Dynamic Linking
- Expression Macro
- Dynamic Linking
- Lab: Using Expression Macro in a mapping
- Lab: Using Dynamic Linking in a mapping
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
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
- Appendix: Creating a Masking Task
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
11: Taskflows
- Taskflow overview
- Linear Taskflows
- File Listener Enhancements
- Taskflow Steps
- Taskflow Templates
- Parameters in Taskflow
- Using REST APIs
- File Listener
- Invoke a Taskflow through a File Listener
- Lab: Passing in-out parameters in a Taskflow
- Lab: Invoking a Taskflow through a File Listener
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
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
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
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
16: Automating and Monitoring Tasks
- Schedules
- Schedule Repeat Frequency
- Schedule Blackout Period
- Schedule Export
- Monitoring tasks
- Email Notifications
- Event Monitoring
- Lab: Creating a schedule
17: 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: Configure Administrative settings for your Informatica Cloud org
- Lab: Creating a sub-organization and importing/exporting assets
- Lab: Managing Assets in Org
18: IICS APIs
- REST API overview
- Informatica Cloud REST API
- REST API Versions
- Request Header and Request Body configuration
- Return Lists
- Lab: Running a Mapping task using REST API
To see the full course content Download now
Course Prerequisites
- Informatica Power Centre knowledge is good to have but not mandatory.
Who can attend
- Developers working with any ETL/Data Integration tool, especially Informatica Power Centre, IBM DataStage and any other ETL Tools
- BI/ETL/DW Professionals
- Analytics Professionals who want to know how the ETL happens on the cloud
- Mainframe Developers and Architects who want to switch to the Data Warehouse and Business Intelligence World
- Individual Contributors in the field of Enterprise Business Intelligence
- Data Warehouse Project Managers
- Database/SQL Developers
Number of Hours: 40hrs
Certification
Key features
- One to One Training
- Online Training
- Fastrack & Normal Track
- Resume Modification
- Mock Interviews
- Video Tutorials
- Materials
- Real Time Projects
- Virtual Live Experience
- Preparing for Certification
FAQs
DASVM Technologies offers 300+ IT training courses with 10+ years of Experienced Expert level Trainers.
- One to One Training
- Online Training
- Fastrack & Normal Track
- Resume Modification
- Mock Interviews
- Video Tutorials
- Materials
- Real Time Projects
- Materials
- Preparing for Certification
Call now: +91-99003 49889 and know the exciting offers available for you!
We working and coordinating with the companies exclusively to get placed. We have a placement cell focussing on training and placements in Bangalore. Our placement cell help more than 600+ students per year.
Learn from experts active in their field, not out-of-touch trainers. Leading practitioners who bring current best practices and case studies to sessions that fit into your work schedule. We have a pool of experts and trainers are composed with highly skilled and experienced in supporting you in specific tasks and provide professional support. 24x7 Learning support from mentors and a community of like-minded peers to resolve any conceptual doubts. Our trainers has contributed in the growth of our clients as well as professionals.
All of our highly qualified trainers are industry experts with at least 10-12 years of relevant teaching experience. Each of them has gone through a rigorous selection process which includes profile screening, technical evaluation, and a training demo before they are certified to train for us. We also ensure that only those trainers with a high alumni rating continue to train for us.
No worries. DASVM technologies assure that no one misses single lectures topics. We will reschedule the classes as per your convenience within the stipulated course duration with all such possibilities. If required you can even attend that topic with any other batches.
DASVM Technologies provides many suitable modes of training to the students like:
- Classroom training
- One to One training
- Fast track training
- Live Instructor LED Online training
- Customized training
Yes, the access to the course material will be available for lifetime once you have enrolled into the course.
You will receive DASVM Technologies recognized course completion certification & we will help you to crack global certification with our training.
Yes, DASVM Technologies provides corporate trainings with Course Customization, Learning Analytics, Cloud Labs, Certifications, Real time Projects with 24x7 Support.
Yes, DASVM Technologies provides group discounts for its training programs. Depending on the group size, we offer discounts as per the terms and conditions.
We accept all major kinds of payment options. Cash, Card (Master, Visa, and Maestro, etc), Wallets, Net Banking, Cheques and etc.
DASVM Technologies has a no refund policy. Fees once paid will not be refunded. If the candidate is not able to attend a training batch, he/she is to reschedule for a future batch. Due Date for Balance should be cleared as per date given. If in case trainer got cancelled or unavailable to provide training DASVM will arrange training sessions with other backup trainer.
Your access to the Support Team is for lifetime and will be available 24/7. The team will help you in resolving queries, during and after the course.
Please Contact our course advisor +91-99003 49889. Or you can share your queries through info@dasvmtechnologies.com