Thursday, December 12, 2024

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






at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

List of taskflows in IICS

ICS provides a list of tasks like linear taskflow, taskflow, parallel tasks, parallel tasks with decision, sequential tasks, sequential task...

  • Update Strategy Transformation
    Update Strategy Transformation is Connected and Active transformation. It is used to insert, update, delete and reject records from a file ...
  • Analytical Functions
    The functions SUM, COUNT, AVG, MIN, MAX are the common aggregate functions the result of which does not depend on the order of the records....
  • Session parameters & Session variables
    Session Parameter :- ---------------------- Session parameters, like mapping parameters, represent values you might want to change betwee...