Release Guide > Part V: Version 9.6.1 > New Features, Changes, and Release Tasks (9.6.1 HotFix 3) > New Features (9.6.1 HotFix 3)
  

New Features (9.6.1 HotFix 3)

This section describes new features in version 9.6.1 HotFix 3.

Business Glossary

This section describes new Business Glossary features in version 9.6.1 HotFix 3.

Delete Draft Assets

Effective in version 9.6.1 HotFix 3, you can delete draft assets before you publish them for the first time. You cannot delete assets that are in the review, published, or rejected phases. You cannot delete drafts after you revise published or rejected assets.
For more information, see the Informatica 9.6.1 HotFix 3 Business Glossary Guide.

Cross Glossary Relationships

Effective in version 9.6.1 HotFix 3, you can create relationships between assets from any glossary. You can link business terms across glossaries. You can link a policy from any glossary to a business term. You can view assets from across glossaries in the relationship view diagram. When you import or export a glossary, you can choose to import or export linked assets from other glossaries.
For more information, see the Informatica 9.6.1 HotFix 3 Business Glossary Guide.

Create Hyperlinks from URLs

Effective in version 9.6.1 HotFix 3, you can create hyperlinks when you insert URLs in the Description, Usage Context, Example, and Reference Table URL properties for business terms. You can link to assets from any glossary.
For more information, see the Informatica 9.6.1 HotFix 3 Business Glossary Guide.

Informatica Data Services

This section describes new Informatica Data Services features in version 9.6.1 HotFix 3.
Query datetime data from Microsoft Access
Effective in version 9.6.1 HotFix 3, you can query an SQL data service that contains datetime data from Microsoft Access. When you configure the Informatica Data Services ODBC Driver, enter the following parameter in the Optional Parameters field in the Configure Data Source to Informatica Data Services dialog box:
APPLICATION=ACCESS
When you configure the ODBC driver with this parameter, the Data Integration Service uses the date/time data type for Microsoft Access date data.

Informatica Transformations

This section describes new Informatica transformation features in version 9.6.1 HotFix 3.

Address Validator Transformation

This section describes the new Address Validator transformation features.
Support for locality and neighborhood identification codes in Belgium addresses
Effective in version 9.6.1 HotFix 3, you can configure the Address Validator transformation to return a code that uniquely identifies the neighborhood that contains a Belgium address. To return the code, select the NIS Code output port. Find the port in the BE Supplementary port group.
The NIS Code port returns the five-digit NIS code that identifies the locality and a four-character code that identifies the neighborhood within the locality. The national statistics directorate in Belgium defines the codes.
To return the data on the NIS Code port, the Address Validator transformation reads supplementary address reference data for Belgium. To verify that the Address Validator transformation can read the supplementary data, add the Supplementary BE Status output port to the transformation. Informatica adds the NIS Code port, the Supplementary BE Status port, and the BE Supplementary port group in version 9.6.1 HotFix 3.
Support for Federal Information Addressing System identifiers in Russian Federation addresses
Effective in version 9.6.1 HotFix 3, you can configure the Address Validator transformation to return the Federal Information Addressing System identifier for an address in the Russian Federation. To return the identifier, select the FIAS ID output port. Find the port in the RU Supplementary port group.
The FIAS ID port returns up to 36 characters. The Federal State Statistics Service of the Russian Federation maintains the identifier data.
To return the data on the FIAS ID port, the Address Validator transformation reads supplementary address reference data for the Russian Federation. To verify that the Address Validator transformation can read the supplementary data, add the Supplementary RU Status output port to the transformation. Informatica adds the FIAS ID port, the Supplementary RU Status port, and the RU Supplementary port group in version 9.6.1 HotFix 3.
Support for unique property reference numbers in Great Britain addresses
Effective in version 9.6.1 HotFix 3, you can configure the Address Validator transformation to return the unique property reference number for an address in Great Britain. The number uniquely identifies the plot of land that contains an address in the United Kingdom. To return the unique property reference number, select the UPRN output port. Find the port in the UK Supplementary port group.
The unique property reference number contains 12 digits. The Ordnance Survey of Great Britain maintains the unique property reference numbers.
To return the data on the UPRN port, the Address Validator transformation reads supplementary address reference data for the Great Britain. To verify that the Address Validator transformation can read the supplementary data, add the Supplementary UK Status output port to the transformation. Informatica adds the UPRN port in version 9.6.1 HotFix 3.
Ability to remove locality and province descriptors from China and Japan addresses
Effective in version 9.6.1 HotFix 3, you can configure the Address Validator transformation to remove locality descriptors and province descriptors from addresses in China and Japan. For example, the Address Validator transformation can return Chaoyang instead of Chaoyangqu and Beijing instead of Beijingshi in Chinese addresses.
To remove the descriptors, configure the Preferred Language property and the Preferred Script property on the transformation.
Ability to validate Bulgaria addresses in Cyrillic script
Effective in version 9.6.1 HotFix 3, you can validate Bulgaria addresses in the Cyrillic script. By default, the Address Validator transformation returns the results in the Cyrillic script.
To receive the results in the Latin script, configure the Preferred Script property on the transformation.
Ability to validate Slovakia addresses that contain street name abbreviations
Effective in version 9.6.1 HotFix 3, you can validate Slovakia addresses that contain major street name abbreviations.
The transformation replaces the abbreviations with the names that the postal authority specifies in the valid address output.
Ability to retrieve province ISO codes in batch, interactive, and fast completion modes
Effective in version 9.6.1 HotFix 3, the Address Validator transformation extends support for ISO 3166-2 province codes to the following countries:
For example, the transformation returns the province code NC, which identifies North Carolina, for the following address:
15501 WESTON PKWY STE 150
CARY 27513
USA
For more information, see the Informatica 9.6.1 HotFix 3 Address Validator Port Reference and the Informatica 9.6.1 HotFix 3 Developer Transformation Guide.

Metadata Manager

This section describes new Metadata Manager features in version 9.6.1 HotFix 3.

Metadata Source Versions

Effective in version 9.6.1 HotFix 3, some metadata sources have new supported versions.
The following metadata sources have new supported versions:
For more information about supported metadata source versions, see the PCAE Metadata Manager XConnect Support Product Availability Matrix on Informatica Network: https://network.informatica.com/community/informatica-network/product-availability-matrices/overview

Cloudera Navigator Resources

Effective in version 9.6.1 HotFix 3, you can enable incremental loading and create search queries to decrease the amount of time it takes for Metadata Manager to load Cloudera Navigator resources.
You can configure the following properties when you create or edit a Cloudera Navigator resource:
Enable incremental load
Enables incremental loading for Cloudera Navigator resources after the first successful resource load. When you enable this option, Metadata Manager loads recent changes to the metadata instead of loading complete metadata.
During an incremental load, Metadata Manager extracts only the following entities:
Search query
Query that limits the HDFS entities that Metadata Manager extracts. By default, Metadata Manager does not extract HDFS entities from certain directories that contain only canary files, log files, history files, or deleted files. You can update the default search query to prevent Metadata Manager from extracting other HDFS entities. The query that you enter must use valid Cloudera Navigator search syntax.
For more information about Cloudera Navigator resources, see the Informatica 9.6.1 HotFix 3 Metadata Manager Administrator Guide.

Microsoft SQL Server Resources

Effective in version 9.6.1 HotFix 3, Metadata Manager extracts the value of the MS_Description extended property for Microsoft SQL Server table and view columns.
For more information about extracting extended properties for Microsoft SQL Server resources, see the Informatica 9.6.1 HotFix 3 Metadata Manager Administrator Guide.

PowerExchange Adapters for PowerCenter

This section describes new PowerCenter adapter features in version 9.6.1 HotFix 3.

PowerExchange for SAP Netweaver

Effective in version 9.6.1 HotFix 3, you can set the AddQuotesForCachedLookup custom session property to Yes. This ensures that sessions do not fail when you use HANA table metadata that contains special characters, symbols, or lowercase characters in cached lookups.

PowerExchange for Greenplum

Effective in version 9.6.1 HotFix 3, you can configure the MAX_LINE_LENGTH attribute in the session properties when you load data to a column. This ensures that you can load data to a column with precision 104857600.