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)

Partitioning

Hive organizes the tables into partitions, and partitions are subdivided into buckets. ALTER TABLE table_name ADD [IF NOT EXISTS] PARTITION ...

  • Update Strategy Transformation
    Update Strategy Transformation is Connected and Active transformation. It is used to insert, update, delete and reject records from a file ...
  • Session parameters & Session variables
    Session Parameter :- ---------------------- Session parameters, like mapping parameters, represent values you might want to change betwee...
  • Real Time Scenarios
    1) A flat file is arrived on the server and workflow will be launched using 'PMCMD' command. After some time another flat file arri...