Informatica Intelligent Cloud Services (IICS)

Explore IICS Configuraion. Integration, Monitoring, Debugging Mapping, Web Services, Peformance Optimization and More

TTINFCLD4

Introductory and Beyond

4 Days

Course Overview

Geared for developers, Informatica’s Intelligent Cloud Services (IICS) is a four day, hands-on Informatica training course that covers the architecture and the data integration features that allows attendees to integrate hybrid environments between cloud-based applications and on-premise systems.  Practical Labs were designed to enhance in depth knowledge of IICS.

Working in a lab-intensive hands-on learning environment, led by our Informatica expert practitioner, you'll explore:

Introduction to the Cloud Interface
Informatica Cloud Architecture
Configuration
Integration Applications
Monitoring and Debugging
Troubleshooting & Security
Informatica Cloud Mapping Designer
Mapping Task
Taskflows
Administration
Web services and Hierarchical transformations
Informatica Cloud Rest API
Performance Optimization
Exception Handling

NOTE: The Informatica Training Series is independent-format training that can be tuned and adjusted to best meet your needs. Our materials are flexible, comprehensive, and are always instructed by a senior instructor with a deep understanding of Informatica and its most current features, benefits and functionality in a wide array of uses. This is not Official Informatica Training.

Course Objectives

Working in a lab-intensive hands-on learning environment, led by our Informatica expert practitioner, you'll explore:

Introduction to the Cloud Interface

  • Informatica Cloud Architecture
  • Configuration
  • Integration Applications
  • Monitoring and Debugging
  • Troubleshooting & Security
  • Informatica Cloud Mapping Designer
  • Mapping Task
  • Taskflows
  • Administration
  • Web services and Hierarchical transformations
  • Informatica Cloud Rest API
  • Performance Optimization
  • Exception Handling

Course Materials & Cloud Set up: Each student will receive digitial course notes, code samples, software tutorials, diagrams and related reference materials and links (as applicable). Our courses also include step by step hands-on lab instructions and and solutions, clearly illustrated for users to complete hands-on work in class, and to revisit to review or refresh skills at any time. Students will also receive the project files (or code, if applicable) and solutions required for the hands-on work.  All course software (limited versions, for course use only), courseware files or course notes (as applicable), labs / data sets and solutions (as applicable) are provided for you in our “easy access / no install required” high-speed remote lab environment.  

Course Prerequisites

This course is geared for Business Analysts and / or developers with prior Informatica experience.

Course Agenda

Please note that this list of topics is based on our standard course offering, evolved from typical industry uses and trends. We’ll work with you to tune this course and level of coverage to target the skills you need most.

Informatica Cloud Overview

  • Introduction to the Cloud Interface
  • Advantages of Informatica Cloud
  • Overview of Cloud Services
  • Integrating Informatica Cloud and PowerCenter

Informatica Cloud Architecture

  • Informatica Cloud Integration Service Architecture
  • Informatica Cloud Secure Agent Architecture

Configuration

  • System Requirements
  • Secure Agent Configuration
  • Creating and Configuring connections
  • Flat File connection features
  • Creating and configuring Schedules
  • Creating queries
  • Exercise #1: Download, Install and Configure the Secure Agent
  • Exercise #2: Creating connections

Integration Applications

  • Configuring a Data Replication Task
  • Configuring a Data Synchronization Task
  • Exercise #3: Data Synchronization
  • Exercise #4: Synchronize Salesforce Contacts
  • Configuring a Data Masking Task
  • Configuring a PowerCenter Task
  • Explain advanced options (i:e Pre and Post-Processing Commands, Operating System Commands, Success and Failure email notifications, Assign parameter file)
  • Configuring a Data Transfer Tasks
  • Configure file listener job

Monitoring and Debugging

  • Activity Monitor Service
  • Debugging task
  • Errors and log files

Troubleshooting

  • Secure Agent
  • Connection
  • Mapping
  • Mapping Task, Synchronization Task, Replication Task, Masking Task, PowerCenter Task, Scheduled Task
  • Security

Informatica Cloud Mapping Designer

  • Overview of the mapping designer
  • Mapping transformations overview: Source, Target, Joiner, Expression, Filter, Aggregator, Rank, Sorter, Normalizer, router, Union, JAVA, sequence generator and Lookup, Data Masking
  • CLAIRE recommendations for source objects
  • Assigning Field Rules to the transformations
  • Create variables and parameters in the mapping
  • Exercise #5: Source and Target Definitions, Simple Mapping
  • Exercise #6: Expression and aggregator transformation
  • Exercise #7: Flat File Source, Joins
  • Exercise #8: Lookup and Rank Transformations
  • Exercise #9: Complex mapping to load Salesforce Data, Router Transformation
  • Exercise #10: Local variables, Sorter Transformation
  • Exercise #11: Using Sorted Input Optimization
  • Exercise #12: Normalizer
  • Data Integration Elastic

Mapping Task

  • Usage of a mapping Task
  • Exercise #13: Slowly Changing Dimension Type I (MappingTask)
  • Data Validation
  • Runajob Utility
  • Dynamic Mapping Task
  • Dynamic Schema Change

Taskflows

  • Usage of Taskflows
  • Configuring a Taskflow
  • Taskflow Inputs
  • Taskflow Functions
  • Command Task
  • Exercise #14: Simple Taskflow and Error Handling
  • Exercise #15: Complex Taskflow
  • Exercise #16: Mapping Parameters

Administration

  • Enabling source control
  • Switch between different organization
  • Create User Roles, User Groups, and Object level permissions
  • Migration
  • Audit logs

Web services and Hierarchical transformations

  • Overview of Web services
  • Usage of web service transformation
  • Hierarchy Parser Transformation
  • Hierarchy Builder Transformation
  • Exercise #17: Create a mapping that uses a web service transformation.
  • Exercise #18: Create a mapping that uses a Hierarchy Parser transformation.
  • Exercise #19: Create a mapping that uses a Hierarchy Builder transformation.
  • Intelligent Structure Discovery

Informatica Cloud Rest API

  • Overview of Rest APIs in Informatica cloud
  • IP Address Filtering
  • Exercise 20: Create a Rest API to run a mapping task

Performance Optimization

  • Overview on Partitioning rules and Guidelines
  • Overview on Pushdown Optimization

Exception Handling

  • Overview of types of exceptions
  • Handling user-defines, fatal and non-fatal exceptions
  • Exercise #21: Create a mapping to handle exceptions

 

Course Materials

Course Materials & Cloud Set up: Each student will receive digitial course notes, code samples, software tutorials, diagrams and related reference materials and links (as applicable). Our courses also include step by step hands-on lab instructions and and solutions, clearly illustrated for users to complete hands-on work in class, and to revisit to review or refresh skills at any time. Students will also receive the project files (or code, if applicable) and solutions required for the hands-on work.  All course software (limited versions, for course use only), courseware files or course notes (as applicable), labs / data sets and solutions (as applicable) are provided for you in our “easy access / no install required” high-speed remote lab environment.  

Raise the bar for advancing technology skills

Attend a Class!

Live scheduled classes are listed below or browse our full course catalog anytime

Special Offers

We regulary offer discounts for individuals, groups and corporate teams. Contact us

Custom Team Training

Check out custom training solutions planned around your unique needs and skills.

EveryCourse Extras

Exclusive materials, ongoing support and a free live course refresh with every class.

Mix, Match & Master!
2FOR1: Two Courses, One Price!

Enroll in *any* two public courses (for 2023 *OR* 2024 dates!) by December 31, for one price!  Learn something new, or share the promo!

Click for Details & Additional Offers

Learn. Explore. Advance!

Extend your training investment! Recorded sessions, free re-sits and after course support included with Every Course
Trivera MiniCamps
Gain the skills you need with less time in the classroom with our short course, live-online hands-on events
Trivera QuickSkills: Free Courses and Webinars
Training on us! Keep your skills current with free live events, courses & webinars
Trivera AfterCourse: Coaching and Support
Expert level after-training support to help organizations put new training skills into practice on the job

The voices of our customers speak volumes

Special Offers
Limited Offer for most courses.

SAVE 50%

Learn More