Informatica transformations

Contact


We offer tranformations/components that are not part of the ETL tool Informatica PowerCentre. Except sophisticated components listed bellow also components performing simple transformations:

  • Change Encoding. It is used for the change in encoding of the input text according to a conversion table. The component can be used to change the code page or it is possible to carry out other conversions, e. g. changing quotation marks to apostrophes, removing diacritics, etc.
  • Data Scrambling. Scrambles sensitive data. The scrambling process changes certain data, such as a birth certificate number, in such way that the genuine number cannot be retrieved from the scrambled data whilst at the same time the scrambled data has the properties of the original birth certificate number. It supports scrambling of plain text, numbers, birth certificate numbers and company identification numbers.
  • Dedup. Identifies duplicities for a determined primary key. The component passes only the first entry for the key to the output; the input records can be sorted or unsorted. The component is designed to be used together with the GTL Checker component and the primary key identification is in the check plan.
  • Demux. It is used for direct entering of data into multiple files; the distribution into files is performed on the basis of one of the attribute.
  • Merge. Merges records from several sorted inputs into a single output and, unlike the Union transformation, it preserves the sorting of records.
  • Generator. Generates and sends new records to an output the number of which is determined by the value at the input port. Each output record contains only one integral number – its order.

    Informatica custom transformation GTL Checker converts data types. On its input can be any number of ports and in the output group the corresponding number of output ports. The output data type determines the conversion is to be performed for incoming records. Data conversions are precisely define by external file – check plan. Check plan specifies for example data format, decimal separator in numbers with decimal point on the input and output, restriction on the not null value, definition of primary key etc. Informatica custom transformation - conversion types Basic type – conversion of data type. Characters set conversion according…

    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…

    The GTL Condition Informatica transformation is used for the evaluation of complex conditional expressions specified in an external file. Main benefits of Informatica transformation Simple definition of complex evaluation conditions. Administration of conditions in an external file enabling editing without interfering with the actual transformation. Implemented numerical arithmetic, operations for strings, date values and boolean values. The component’s language is easily extendable to include more user-defined functions. Up to 15% faster processing. The logic of the expression evaluation is similar to the case expression of the SQL language with a slightly extended logic. Compared to the normal behaviour, one of…