4.67 out of 5
6 reviews on Udemy

Informatica Cloud – Data Integration

IICS - Informatica Intelligent Cloud Services (Data Integration)
Sid Inf
64 students enrolled
English [Auto-generated]
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 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 .

Introduction and Prerequisites

Introduction and Prerequisites to IICS

Introduction and Prerequisites to IICS

The Basics

What is Cloud Computing?

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.

What are the different types of Cloud Computing?

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

Infrastructure as a Service - IaaS

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. 

Platform as a Service - PaaS

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 Salesforce.com’s Force.com, Rackspace Cloud Sites, Google App Engine and Microsoft Azure.

Software as a Service - SaaS

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.

Let's order Pizza!! --> Cloud Computing types examples

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

IICS - Informatica Intelligent Cloud Services

What is IPaas?

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.

Power Center On premise Vs Informatica Cloud

Difference between Informatica Power Center on premise setup and IICS

Power Center On Cloud Vs Informatica Cloud

Difference between Informatica Power Center On cloud setup and IICS

Different Components of Informatica Cloud

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

Informatica Cloud Architecture

Informatica Cloud Architecture overview

Informatica Cloud Connectivity and Secure Agent

Informatica Cloud Connectivity and Secure Agent

Commonly used terms

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

Getting Started with IICS

How to create a Informatica Cloud account?

Steps to create 30 cloud trail account on Informatica Cloud

What are the different Services available in Informatica Cloud?

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

Data Integration Service - Page Layout

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

Administration Service - Page Layout

Administrator Page layout and different options available.

Monitor Service - Page Layout

Monitor Service - Page Layout

Steps to download and install secure agent

Steps to download and install the secure agent.

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

Data Integration Service

Folder Creation under Explore Option

Steps to create a folder and renaming it.

Mapping Designer - Layout

This lecture describes the mapping designer and the layout options.

How to configure a reusable Flat File connection?

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

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

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

Steps to create the mapping and execute it.

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

Secure Agent Setup and Re-usable Connection creation

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.   

Copy to and Move to options

Copy to and Move to options in Informatica Cloud.

How are the environments setup work in the cloud?

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

What are Sub Organizations and how to link Sub Organizations?

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

Mapping creation without any linking of ports

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

Transformations in Informatica Cloud

Introduction to Transformations in Informatica Cloud

This lecture covers the overall transformations available in Informatica Cloud.

Aggregator Transformation - Properties and Example

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

Sorter Transformation - Properties, Example --> Part 1

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 2

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

Filter Transformation - Properties, Example

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.

Router 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.

Sequence Generator 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. 

Union 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. 

Source Type - File List

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

Lookup Transformation - Properties, Example

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.

Unconnected 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. 

Normalizer Transformation

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

Business Use Case

Business Use Case Introduction

Introduction to business use case.

Sources and Targets used for the Use Case

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


Introduction to Tasks

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

Mapping Task - Creation and Example

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

Synchronization Task

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

Database to Database Replication Example

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

Database to File Replication Example

This lecture covers the example of Database to Flat File.

PowerCenter Task - Import of Workflow XML and Example

This lecture explains the PowerCenter Tasks in Informatica Cloud.

Scheduling in Informatica Cloud

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

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


Direct links to other courses

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

You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.7 out of 5
6 Ratings

Detailed Rating

Stars 5
Stars 4
Stars 3
Stars 2
Stars 1
30-Day Money-Back Guarantee


5 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion