Informatica Transformations
Read this section to learn what's new with Developer tool transformations in version 10.5.
Data Masking Transformation
Effective in version 10.5, you can perform the following tasks in a Data Masking transformation:
- Encryption
- You can use the encryption technique to encrypt or decrypt source data. You can configure the technique to preserve format and metadata, preserve metadata, or change the metadata.
- Sort order
- You can sort the order of entries in a relational dictionary that you use for Substitution masking. Sort the order of entries in the dictionary based on the serial number column to ensure that the order remains consistent and generates consistent masked data.
- Optimize dictionary usage
- Optimize dictionary usage to increase the number of masked values used from the dictionary in a Substitution masking technique that you configure for repeatable output.
For information, see the "Data Masking Transformation" chapter in the Informatica 10.5 Developer Transformation Guide.
Lookup Transformation
Effective in version 10.5, the Spark engine and the Databricks Spark engine can return multiple matches for a Lookup transformation.
Sequence Generator Transformation on Databricks
Effective in version 10.5, the Databricks Spark engine can process the Sequence Generator transformation on Amazon Web Services (AWS) or Microsoft Azure Databricks clusters.
The Sequence Generator transformation is supported on Databricks when the Databricks cluster and the Informatica domain reside in the same virtual network.