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