Informatica Transformations

Informatica Transformations

Informatica Transformations are a part of a mapping that represent the operations that you want to perform on data. Transformations also define how data enters each transformation.

These are repository Objects that are used to perform aggregations, sorting, merging, modifying, distributing, etc., while passing data through them.

Types of Informatica Transformations

Conceptually informatica has two transformations named as Active and Passive.

An active transformation can change the number of rows that pass through the transformation. For example, the Filter transformation is active because it removes rows that do not meet the filter condition.

A passive transformation does not change the number of rows that pass through the transformation.

You can connect multiple branches to a downstream passive transformation when all transformations in the branches are passive.

You cannot connect multiple active transformations or an active and a passive transformation to the same downstream transformation or transformation input group in addition You might not be able to concatenate the rows. An active transformation changes the number of rows so it might not match the number of rows from another transformation.

TransformationDescription
SourceReads data from a source.
TargetWrites data to a target.
AggregatorAn active transformation that performs aggregate calculations on groups of data.
CleanseA passive transformation that adds a cleanse asset that you created in Data Quality to a mapping or mapplet. Use a cleanse asset to standardize the form and content of your data.
Data MaskingA passive transformation that masks sensitive data as realistic test data for non production environments.
Data ServicesAn active transformation that invokes data services from the data services repository, including industry-standard services, such as HL7 and HIPAA, and customized services.
DeduplicateAn active transformation that adds a deduplicate asset that you created in Data Quality to a mapping or mapplet so Use a deduplicate asset to find instances of duplicate identities in a data set and optionally to consolidate the duplicates into a single record.
ExpressionA passive transformation that performs calculations on individual rows of data.
FilterAn active transformation that filters data from the data flow.
Hierarchy BuilderAn active transformation that converts relational input into hierarchical output.
Hierarchy ParserA passive transformation that converts hierarchical input into relational output.
Hierarchy ProcessorAn active transformation that converts hierarchical input into relational output, or relational input into hierarchical output or hierarchical output into hierarchical output of a different schema or hierarchical input into denormalized flattened output.
InputA passive transformation that passes data into a mapplet. Can be used in a mapplet, but not in a mapping.
JavaExecutes user logic coded in Java. Can be active or passive.
JoinerAn active transformation that joins data from two sources.
LabelerA passive transformation that adds a labeler asset that you created in Data Quality to a mapping or mapplet so Use a labeler asset to identify the types of information in an input field and to assign labels for each type to the data.
LookupLooks up data from a lookup object. Defines the lookup object and lookup connection. Also defines the lookup condition and the return values. A passive lookup transformation returns one row. An active lookup transformation returns more than one row.
Machine LearningRuns a machine learning model and returns predictions to the mapping.
MappletInserts a mapplet into a mapping or another mapplet. A mapplet contains transformation logic that you can create and use to transform data before it is loaded into the target. Can be active or passive based on the transformation logic in the mapplet.
NormalizerAn active transformation that processes data with multiple-occurring fields and returns a row for each instance of the multiple-occurring data.
OutputA passive transformation that passes data from a mapplet to a downstream transformation. Can be used in a mapplet, but not in a mapping.
ParseA passive transformation that adds a parse asset that you created in Data Quality to a mapping or mapplet. Use a parse asset to parse the words or strings in an input field into one or more discrete output fields based on the types of information that the words or strings contain.
PythonRuns Python code that defines transformation functionality. Can be active or passive.
RankAn active transformation that limits records to a top or bottom range.
RouterAn active transformation that you can use to apply a condition to incoming data.
Rule SpecificationA passive transformation that adds a rule specification asset that you created in Data Quality to a mapping or mapplet. Use a rule specification asset to apply the data requirements of a business rule to a data set.
Sequence GeneratorA passive transformation that generates a sequence of values.
SorterA passive transformation that sorts data in ascending or descending order, according to a specified sort condition.
SQLCalls a stored procedure or function or executes a query against a database. Passive when it calls a stored procedure or function. Can be active or passive when it processes a query.
Structure ParserA passive transformation that analyzes unstructured data from a flat file source and writes the data in a structured format.
Transaction ControlAn active transformation that commits or rolls back sets of rows during a mapping run.
UnionAn active transformation that merges data from multiple input groups into a single output group.
VelocityA passive transformation that executes a Velocity script to convert JSON or XML hierarchal input from one format to another without flattening the data.
VerifierA passive transformation that adds a verifier asset that you created in Data Quality to a mapping or mapplet so Use a verifier asset to verify and enhance postal address data.
Web ServicesAn active transformation that connects to a web service as a web service client to access, transform, or deliver data.

Go to previous page

Scroll to top