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