Informatica custom transformation – GTL Consolidation

Informatica custom transformation GTL Consolidation consolidates historical data using external consolidation plan. Historical data are data collecting an entire history of the object, not only current status. Each record of the object has a validity interval in time. New record is created with consequential validity interval when the change of the monitored object attributes occurs, validity of the original record is finished. Informatica custom transformation is able to perform consolidation of the entire historical sets with group records which needs to be added, corrected or terminate its validity. Consolidation plan (consol plan) is an external file with information needed for consolidation at the level of each ports. Each record in the file contains two fields – name of the port and type of the port. The name of the port corresponds with the name of the port in the group working, type of the port determines which role has port while consolidates.

Informatica custom transformation input groups

  • Group working contains data, which needs to be consolidate with historical data, which means data records for a certain period. One group can contain only data changes or entire time record.
  • Group target contains historical data, that means the history of each record/object. Data are consolidated with data from input working.

Informatica custom transformation output groups

  • Group output – new records, which needs to be added to historical data, so than can collect consolidated changes.
  • Group original – on this output are send target records for to reduce validity, because there are working record with changed attributes or records on the input. These changed records or attributes does not exist on the new record and its validity should be terminated.

Input and output groups of component

Consolidation plan – port type values

Port or ports belong to primary key or belong to composite primary key. Input is classified in ascending order by these ports and by its ranking in the working group.
Port with data of the beginning of the validity interval record. Must be stated only for one port.
Port with data of the end validity interval records. Must be stated just for one port.
Port with working type record -„i“ (insert), „u“ (update), „d“ (delete). Values „i“ and „u“ closes older records and loading of new record with the identical primary key. Value „d“ means just closing of older file with identical primary key. Must be stated only for one port.
Port should be tract for changes. The value change of any tract ports causes loading of another output file. Can be stated for more ports.
Port is not tracked for changes. This port changes do not enforce load of new record but are only updated for new values.
Port is not traced for changes. This value changes of this port do not enforce load of new record and are used only for loading of new file.
Port change is ignored. Changes of this port do not enforce load of new record, and are never updated with new values.


Globtech, Karlovo náměstí 16, 120 00 Prague, Czech republic