List of tasks in IICS

IICS provides a list of tasks like mapping task, powercenter tasks, synchronization task, replication task, masking task, dynamic mapping tasks, and data transfer tasks.

MAPPING TASK: This task is similar to the informatica session task

SYNCHRONIZATION TASK: This task is used to synchronize data from source to target.

- It is used for Analytical purpose or Business Intelligence purposes.
- Full or incremental data replication can be done from source to target.

REPLICATION TASK: This task is used to replicate or copy the data from source to target

- Insert, update, delete, and upsert can be implemented here.

DYNAMIC TASK: This task is used when there are multiple sources and targets and we want to run them with a single mapping.

POWER CENTER TASK: This task is used to import Xml files from PowerCenter to IICS

Transformations in IICS

IICS consists of a few transformations that are similar to the Informatica Power Center.
Some of the transformations are Expression, Filter, Joiner, Lookup, Router, Aggregator, Sorter, Stored Procedure (SQL), Rank, Union, Sequence, Normalizer, and Transaction Control.

Below is the list of transformation properties screenshots we use in mappings.

EXPRESSION TRANSFORMATION:

FILTER TRANSFORMATION:

JOINER TRANSFORMATION:

CONNECTED LOOKUP TRANSFORMATION:

UNCONNECTED LOOKUP TRANSFORMATION

ROUTER TRANSFORMATION:

AGGREGATOR TRANSFORMATION:

SORTER TRANSFORMATION:

STORED PROCEDURE OR SQL TRANSFORMATION:

RANK TRANSFORMATION:

UNION TRANSFORMATION:

SEQUENCE TRANSFORMATION:

NORMALIZER TRANFORMATION:

TRANSACTION CONTROL TRANSFORMATION:

STRUCTURE PARSER TRANSFORMATION

Introduction to IICS

IICS stands for Informatica Intelligent Cloud Services. It is a cloud-based platform that can be accessed by using a web browser. It is used to integrate, transform, and manage data across cloud applications and Onprem systems.It's a new approach to the old traditional approach of using OnPrem client tools.

There are few difference between Power Center and IICS

- Powercenter is a traditional, on-premise data integration tool, while IICS is a cloud-based data integration platform (SaaS).

- IICS can be accessed via the internet, while PowerCenter requires client applications to be installed on the server.

- IICS can integrate and synchronize data and applications across cloud and on-premise environments. PowerCenter can only access on-premise data sets.

- IICS provides a process developer tool that allows developers to create connectors to access third-party applications. PowerCenter does not have a similar tool.

- IICS is built on a microservices-based architecture, while PowerCenter uses a client-server architecture.