Transformations
This section describes changed transformation behavior in version 10.1.
Informatica Transformations
This section describes the changes to the Informatica transformations in version 10.1.
Address Validator Transformation
This section describes the changes to the Address Validator transformation.
The Address Validator transformation contains the following updates to address functionality:
- Address validation engine upgrade
- Effective in version 10.1, the Address Validator transformation uses version 5.8.1 of the Informatica Address Verification software engine. The engine enables the features that Informatica adds to the Address Validator transformation in version 10.1.
- Previously, the transformation used version 5.7.0 of the Informatica AddressDoctor software engine.
- Product name change
- Informatica Address Verification is the new name of Informatica AddressDoctor. Informatica AddressDoctor became Informatica Address Verification in version 5.8.0.
- Changes to geocode options for United Kingdom addresses
- Effective in version 10.1, you can select Rooftop as a geocode data property to retrieve rooftop-level geocodes for United Kingdom addresses.
- Previously, you selected the Arrival Point geocode data property to retrieve rooftop-level geocodes for United Kingdom addresses.
- If you upgrade a repository that includes an Address Validator transformation, you do not need to reconfigure the transformation to specify the Rooftop geocode property. If you specify rooftop geocodes and the Address Validator transformation cannot return the geocodes for an address, the transformation does not return any geocode data.
- Support for unique property reference numbers in United Kingdom input data
- Effective in version 10.1, the Address Validator transformation has a UPRN GB input port and a UPRN GB output port.
- Previously, the transformation had a UPRN GB output port.
- Use the input port to retrieve a United Kingdom address for a unique property reference number that you enter. Use the UPRN GB output port to retrieve the unique property reference number for a United Kingdom address.
These features are also available in 9.6.1 HotFix 4. They are not available in 10.0.
For more information, see the Informatica 10.1 Address Validator Port Reference.
Data Processor Transformation
This section describes the changes to the Data Processor transformation.
Excel 2013
Effective in version 10.1, the ExcelToXml_03_07_10 document processor can process Excel 2013 files. You can use the document processor in a Data Processor transformation as a pre-processor that converts the format of a source document before a transformation.
For more information, see the Informatica 10.1 Data Transformation User Guide.
Performance Improvement with Avro or Parquet Input
A Data Processor transformation receives Avro or Parquet data input from a complex file reader object. Effective in version 10.1, you can configure the complex file reader settings to optimize performance for Avro or Parquet input.
For more information, see the Informatica10.1 Data Transformation User Guide.
Performance Improvement with COBOL Input in the Hadoop Environment
Effective in version 10.1, you can configure the complex file reader settings to optimize performance when processing large COBOL files in a Hadoop environment. Use a regular expression to define how to split record processing for an appropriate COBOL input file.
For more information, see the Informatica10.1 Data Transformation User Guide.
Exception Transformations
Effective in version 10.1, you can configure a Bad Record Exception transformation and a Duplicate Record Exception transformation to create exception tables in a non-default database schema.
Previously, you configured the transformations to create exception tables in the default schema on the database.
This feature is also available in 9.6.1 HotFix 4. It is not available in 10.0.
For more information, see the Informatica 10.1 Developer Transformation Guide.