Informatica Cloud - Data Integration
4.3 (359 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,310 students enrolled

Informatica Cloud - Data Integration

IICS - Informatica Intelligent Cloud Services (Data Integration)
Bestseller
4.3 (359 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,310 students enrolled
Created by Sid Inf, Shiva S
Last updated 5/2019
English
English [Auto-generated]
Current price: $64.99 Original price: $99.99 Discount: 35% off
3 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
Requirements
  • Informatica Power Center knowledge is good to have but not mandatory.
Description

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?
02:50

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
01:00

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.

Platform as a Service - PaaS
01:18

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
01:33

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
03:46
+ 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?
03:50

Difference between Informatica Power Center on premise setup and IICS

Power Center On premise Vs Informatica Cloud
05:27

Difference between Informatica Power Center On cloud setup and IICS

Power Center On Cloud Vs Informatica Cloud
02:15

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

Different Components of Informatica Cloud
06:25

Informatica Cloud Architecture overview

Informatica Cloud Architecture
05:30

Informatica Cloud Connectivity and Secure Agent

Informatica Cloud Connectivity and Secure Agent
04:12

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

Commonly used terms
01:50
+ 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?
04:39

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

What are the different Services available in Informatica Cloud?
04:57

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

Data Integration Service - Page Layout
04:26

Administrator Page layout and different options available.

Administration Service - Page Layout
07:15

Monitor Service - Page Layout

Monitor Service - Page Layout
01:12

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
04:41
+ Data Integration Service
10 lectures 01:00:12

Steps to create a folder and renaming it.

Folder Creation under Explore Option
01:58

This lecture describes the mapping designer and the layout options.

Mapping Designer - Layout
05:28

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?
01:27

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?
02:03

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.
17:38

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
04:13

Copy to and Move to options in Informatica Cloud.

Copy to and Move to options
06:27

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?
04:27

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

What are Sub Organizations and how to link Sub Organizations?
03:31

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
13:00
+ 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
13:42

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

Aggregator Transformation - Properties and Example
11:43

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
04:48

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

Sorter Transformation - Properties, Example --> Part 2
04:14

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
09:45

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
07:56

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
06:39

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
09:30

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
04:10

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
10:56

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
06:27

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

Normalizer Transformation
06:43
+ Business Use Case
2 lectures 03:51

Introduction to business use case.

Business Use Case Introduction
02:23

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

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

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

Introduction to Tasks
02:00

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

Mapping Task - Creation and Example
01:59

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

Synchronization Task
05:26

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

Database to Database Replication Example
10:23

This lecture covers the example of Database to Flat File.

Database to File Replication Example
03:58

This lecture explains the PowerCenter Tasks in Informatica Cloud.

PowerCenter Task - Import of Workflow XML and Example
10:40
+ 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?
07:03
+ Bonus
1 lecture 01:37

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

Direct links to other courses
01:37