Informatica Cloud - Data Integration
4.2 (417 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,457 students enrolled

Informatica Cloud - Data Integration

IICS - Informatica Intelligent Cloud Services (Data Integration)
4.2 (417 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,457 students enrolled
Created by Sid Inf, Shiva S
Last updated 6/2020
English [Auto]
Current price: $69.99 Original price: $99.99 Discount: 30% off
11 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 4.5 hours on-demand video
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Understand and Identify the different Cloud Computing Types
  • All the aspects for one to get started with Informatica Cloud Data Integration Service (IICS)
  • All related Administration activities for Data Integration Service/Module
  • Step by step aspects for creating mapping, mapping tasks and linear task flows on the cloud
  • Create and Execute Data Synchronization and Data Replication tasks
  • Migration aspects of Informatica Data Integration Service
  • Connectivity to multiple cloud based and on-premise technologies
  • Informatica Power Center knowledge is good to have but not mandatory.

Informatica Cloud is a data integration solution and platform that works like Software as a Service (SaaS). It integrates cloud-based data with the data residing in on-premise databases and systems or between cloud applications.

Informatica Cloud Data Integration is the cloud based Power Center which delivers accessible, trusted, and secure data to facilitate more valuable business decisions. Informatica Cloud Data Integration can help you and your  organization with global, distributed data warehouse and analytics projects.

If you are using a cloud data warehouse like AWS Redshift, Azure SQL Data Warehouse, or Snowflake, you can use Informatica Cloud Data Integration solutions to help improve the overall performance, productivity, and extensive connectivity to cloud and on-premises sources. 

Informatica Cloud can connect to on-premises and cloud-based applications (like Salesforce, Marketo, NetSuite, Workday) databases, flat files, file feeds, and social networking sites .

Who this course is for:
  • Developers working with any ETL/Data Integration tool, especially Informatica Power Center, 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
Course content
Expand all 52 lectures 04:42:31
+ The Basics
6 lectures 14:11

Cloud computing is the delivery of computing services like servers, storage, databases, networking, software, analytics, intelligence and more over the Internet (“the cloud”) to offer faster innovation, flexible resources, and economies of scale.

Preview 03:44

In this lecture, we understand what are the major types of Cloud Computing

What are the different types of Cloud Computing?

IaaS is the lowest level of cloud solution and refers to cloud-based computing infrastructure as a fully-outsourced service. An IaaS provider will deliver pre-installed and configured hardware or software through a virtualized interface. What the customers accessing the cloud services do with the service is up to them.

Examples of IaaS offerings are managed hosting and development environments. 

Infrastructure as a Service - IaaS

This type of cloud computing is similar to IaaS but is more advanced. With PaaS, apart from simply providing infrastructure, providers also offer a computing platform and solution stack as a service.The IT infrastructure may come with a graphic user interface, run-time system libraries, programming languages or an operating system.

Examples of PaaS solutions include’s, Rackspace Cloud Sites, Google App Engine and Microsoft Azure.

Platform as a Service - PaaS

SaaS providers provide fully functionally web-based applications on demand to customers. The applications are mainly targeted at business users and can include web conferencing, ERP, CRM, email, time management, project tracking among others.

Examples of companies that offer SaaS solutions include Citrix, NetSuite, and others.

Software as a Service - SaaS

All the types of Cloud Computing explained by  making the Pizza or take and bake or dine in options.

Let's order Pizza!! --> Cloud Computing types examples
+ IICS - Informatica Intelligent Cloud Services
7 lectures 29:29

Integration platform as a service (iPaaS) is a set of automated tools for connecting software applications that are deployed in different environments. iPaaS is often used by large  enterprises that need to integrate on-premises applications and data with cloud applications and data.

What is IPaas?

Difference between Informatica Power Center on premise setup and IICS

Power Center On premise Vs Informatica Cloud

Difference between Informatica Power Center On cloud setup and IICS

Power Center On Cloud Vs Informatica Cloud

In this lecture, lets's understand the different components of Informatica Cloud

Different Components of Informatica Cloud

Informatica Cloud Architecture overview

Informatica Cloud Architecture

Informatica Cloud Connectivity and Secure Agent

Informatica Cloud Connectivity and Secure Agent

This lecture covers the different terms used as part of the mapping in Informatica Cloud.

Commonly used terms
+ Getting Started with IICS
6 lectures 27:10

Steps to create 30 cloud trail account on Informatica Cloud

How to create a Informatica Cloud account?

Let's look at the different services as part of the cloud trail license.

What are the different Services available in Informatica Cloud?

Let's quickly look at the layout of the Data Integration service page.

Data Integration Service - Page Layout

Administrator Page layout and different options available.

Administration Service - Page Layout

Monitor Service - Page Layout

Monitor Service - Page Layout

Steps to download and install the secure agent.

The default path for checking the secure agent logs is also discussed in this lecture.

Steps to download and install secure agent
+ Data Integration Service
10 lectures 01:00:12

Steps to create a folder and renaming it.

Folder Creation under Explore Option

This lecture describes the mapping designer and the layout options.

Mapping Designer - Layout

Steps to configure and create the flat file connection which will transfer data using the Secure Agent.

How to configure a reusable Flat File connection?

Steps to configure and create the relational connection which will transfer data using the Secure Agent.

How to configure a reusable Relational connection for an on-premise database?

This lecture covers the steps to create a mapping using the flat file connection created in the earlier lecture.

Steps to create the mapping and execute it.

As we are creating a new 30 day trail account we have to setup the Secure agent and the connections again. This lecture covers the steps..once again.   

Secure Agent Setup and Re-usable Connection creation

Copy to and Move to options in Informatica Cloud.

Copy to and Move to options

In this lecture we talk about the different environments and how they are setup in the Informatica Cloud.   

How are the environments setup work in the cloud?

This lecture, covers the information related to Sub-Organizations and linking the Sub-Organizations.

What are Sub Organizations and how to link Sub Organizations?

Let's create a mapping using Joiner and Filter transformation and run it without a need to link any ports from Source to Target.   

Mapping creation without any linking of ports
+ Transformations in Informatica Cloud
12 lectures 01:36:33

This lecture covers the overall transformations available in Informatica Cloud.

Introduction to Transformations in Informatica Cloud

Aggregator Transformation: An active transformation that performs aggregate calculations on groups of data. 

Aggregator Transformation - Properties and Example

Sorter transformation in Informatica is used to sort the data in an ascending or descending order based on single or multiple keys. This is an active transformation which sorts the data either in ascending order or descending order.

Sorter Transformation - Properties, Example --> Part 1

This is the part 2 of Sorter transformation example and properties.

Sorter Transformation - Properties, Example --> Part 2

Filter Transformation is an active transformation as it changes the no of records. Using the filter transformation, we can filter the records based on the filter condition. Filter transformation is an active transformation as it changes the no of records.

Filter Transformation - Properties, Example

Router transformation is single input to multiple output group transformationRouters can be used in place of multiple Filter transformationsRouter transformations accept the data through an input group once, and based on the output groups you define, it sends the data to multiple output ports.

Router Transformation - Properties, Example

The Sequence Generator Transformation in Informatica is a connected transformation that generates numeric values. We can mainly use thistransformation to generate primary keys, foreign keys or to fill or replace the missing primary keys with unique ones. 

Sequence Generator Transformation - Properties, Example

The Union Transformation in Informatica is used to combine data from multiple sources (excel files, flat file etc) or multiple SQL tables and produce one output to store in the target table. This transformation is an active transformation and it is similar to the SQL Union All. 

Union Transformation - Properties, Example

In this lecture we use a feature called File List to combine all the related files and load it into one.

Source Type - File List

The Lookup transformation is used to look up a source, source qualifier, or target to get the relevant data. You can look up flat file and relational tables.

Lookup Transformation - Properties, Example

An Unconnected Lookup Transformation receives input from the result of an expression in another transformation. A connected lookup can return multiple columns from the same row. But as an Unconnected Lookup is called from another transformation, it can pass only one output value. 

Unconnected Lookup Transformation - Properties, Example

The Normalizer Transformation in Informatica is an Active, and Connected transformation. This transformation is used to normalize the denormalized data.

Normalizer Transformation
+ Business Use Case
2 lectures 03:51

Introduction to business use case.

Business Use Case Introduction

In this lecture, we will take a quick look at the source and the target structure.   

Sources and Targets used for the Use Case
+ Tasks
6 lectures 34:26

This lecture covers the different types of tasks available in 'Informatica Cloud'

Introduction to Tasks

In this lecture, we see the steps to create a mapping task.

Mapping Task - Creation and Example

This lecture shows the steps in the wizard for Synchronization tasks.

Synchronization Task

This lecture covers the steps to replicate the tasks from one Oracle Schema to another.   

Database to Database Replication Example

This lecture covers the example of Database to Flat File.

Database to File Replication Example

This lecture explains the PowerCenter Tasks in Informatica Cloud.

PowerCenter Task - Import of Workflow XML and Example
+ Scheduling in Informatica Cloud
1 lecture 07:03

How to setup reusable and non-reusable schedules in Informatica Cloud?

How to setup reusable and non-reusable schedules in Informatica Cloud?
+ Bonus
1 lecture 01:37

This section will provide you with the coupons for other courses.

Direct links to other courses