Informatica Cloud – Data Integration

Introduction and Prerequisites to IICS

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.

In this lecture, we understand what are the major 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. 

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.

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.

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

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.

Difference between Informatica Power Center on premise setup and IICS

Difference between Informatica Power Center On cloud setup and IICS

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

Informatica Cloud Architecture overview

Informatica Cloud Connectivity and Secure Agent

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

Steps to create 30 cloud trail account on Informatica Cloud

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

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

Administrator Page layout and different options available.

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 create a folder and renaming it.

This lecture describes the mapping designer and the layout options.

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

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

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

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 in Informatica Cloud.

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

This lecture, covers the information related to Sub-Organizations and linking the 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.   

This lecture covers the overall transformations available in Informatica Cloud.

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

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.

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

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 is single input to multiple output group transformation. Routers can be used in place of multiple Filter transformations. Router 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.

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. 

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. 

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

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.

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. 

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

Introduction to business use case.

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

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

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

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

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

This lecture covers the example of Database to Flat File.

This lecture explains the PowerCenter Tasks in Informatica Cloud.

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

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