New Features (9.6.1 HotFix 2)

Business Glossary (9.6.1 HF2)

Refresh Asset

Effective in version 9.6.1 HotFix 2, you can refresh an asset in the Glossary workspace. Refresh the asset to view updates to the properties that content managers made after you opened the asset.

For more information, see the Informatica 9.6.1 HotFix 2 Business Glossary Guide.

Alert for Duplicate Asset Name

Effective in version 9.6.1 HotFix 2, the Analyst tool displays an alert when you try to create an asset with a name that already exists in the glossary. You can ignore the alert and create the asset with a duplicate name.

For more information, see the Informatica 9.6.1 HotFix 2 Business Glossary Guide.

LDAP Authentication in Business Glossary Desktop

Effective in version 9.6.1 HotFix 2, you can use an LDAP domain when you configure server settings to enable the Business Glossary Desktop client to reference the business glossary on a machine that hosts the Analyst Service.

For more information, see the Informatica 9.6.1 HotFix 2 Business Glossary Desktop Installation and Configuration Guide.

Command Line Programs

isp Command

Connectivity

Amazon Redshift Connectivity

Informatica Developer

Microsoft SQL Server Datetime2 Data Type

Effective in version 9.6.1 HotFix 2, Informatica Developer supports the Microsoft SQL Server Datetime2 data type. The Datetime2 data type can store a range of values from Jan 1, 0001 A.D. 00:00:00 to Dec 31, 9999 A.D. 23:59:59.9999999.

Informatica Transformations

Address Validator Transformation

Support for Taiwan addresses in the Mandarin Traditional Chinese script

Effective in version 9.6.1 HotFix 2, you can use the Address Validator transformation to validate Taiwan addresses in the Mandarin Traditional Chinese script. You can use ports from the Discrete or Multiline group to define the input address.

To enter a Mandarin Traditional Chinese address on single line, use the Formatted Address Line 1 port.

Enhancements to United States address validation

Effective in version 9.6.1 HotFix 2, the Address Validator transformation returns the county name when the address contains a valid ZIP code and locality. The transformation can add the county name regardless of an Ix match status for the address. The transformation adds the name to a Province output port. If the state identifier is absent from the address, the transformation adds the state identifier to a Province port.

When you validate an address that contains hyphenated house numbers, the transformation moves the second part of the house number to a Sub-building port.

Configurable output format for element descriptors

Effective in version 9.6.1 HotFix 2, you can configure the Address Validator transformation to specify the output format for the following elements:

• - Street, building, and sub-building descriptors in Australia and New Zealand addresses
• - Street descriptors in German addresses.

By default, the transformation returns the descriptor that the reference database specifies for the address. To specify the output format for the descriptors, configure the Global Preferred Descriptor property on the transformation.

Support for Address Key codes in United Kingdom Addresses

Effective in version 9.6.1 HotFix 2, you can return the address key for a United Kingdom address. The address key is an eight-digit numeric code identifies the address in the Postcode Address File from the Royal Mail. To add the address key to an address, select the Address Key port. To return the address key, the transformation reads supplementary reference data for the United Kingdom.

Extended data support for Japan

Effective in version 9.6.1 HotFix 2, the Address Validator transformation can validate Ban or block information in a Japan address. The Address Validator transformation writes the data to the Street Name 2 port or an equivalent port for dependent street data.

A Japanese address lists the address elements in order of size, from the largest or most general unit to the smallest or most specific unit. The Ban element follows the Chome element and precedes the Go element in the address.

Enhancements to Japan address validation

Effective in version 9.6.1 HotFix 2, you can configure the Address Validator transformation to add the Gaiku code to a Japanese address. To add the code to the address, select the Gaiku Code port.

You can combine the current Choumei Aza code and the Gaiku code in a single string and return the address that the codes identify. To return the complete address, select the Choumei Aza and Gaiku Code JP port and configure the transformation to run in address code lookup mode.

The Japanese reference data contains the Gaiku code, the current Choumei Aza code, and any earlier version of the Choumei Aza code for the address. When you set the Matching Extended Archive property to ON, the transformation writes all of the codes to the output address.

Support for seven-digit postal codes in Israel

Effective in version 9.6.1 HotFix 2, the Address Validator transformation supports the seven-digit postal codes that Israel Post defines for addresses in Israel. The seven-digit postal codes replace the five-digit postal codes that Israel post previously defined. For example, the seven-digit postal code for Nazareth in Israel is 1623726. Previously, the postal code for Nazareth was 16237.

Enhancement to address validation in Germany, Austria, and Switzerland

Effective in version 9.6.1 HotFix 2, the Address Validator transformation recognizes keywords, such as Zimmer and App, in the Street Number ports for addresses from Germany, Austria, and Switzerland. The Address Validator transformation writes the keywords to sub-building ports in the output address.

Support for the IRIS code in French addresses

Effective in version 9.6.1 HotFix 2, you can configure the Address Validator transformation to add the IRIS code to an address in France. To add the code to the address, select the INSEE-9 Code output port.

An IRIS code uniquely identifies a statistical unit in a commune in France. INSEE, or the National Institute for Statistics and Economic Research in France, defines the codes. France has approximately 16,000 IRIS units.

Support for rooftop geocoding in the United Kingdom

Effective in version 9.6.1 HotFix 2, you can configure the Address Validator transformation to return rooftop-level geocodes for United Kingdom addresses. Rooftop geocodes identify the center of the primary building on a site or a parcel of land.

To generate the rooftop geocodes, set the Geocode Data Type property on the transformation to Arrival Point. You must also install the Arrival Point reference data for the United Kingdom.

Improved address reference data for Spain

Effective in version 9.6.1 HotFix 2, Informatica updates the address reference data for Spain. The Address Validator transformation can use the address reference data to validate sub-building-level information in Spanish addresses.

Improved address validation and address reference data for Turkey

Effective in version 9.6.1 HotFix 2, Informatica updates the address reference data for Turkey.

The Address Validator transformation can also perform the following operations when it validates Turkish addresses:

• - The transformation can identify a building name and a street name on the Delivery Address Line 1 port.
• - The transformation adds a slash symbol (/) between a building element and a sub-building element when the sub-building element is a number.

Improved address validation for Brazil

Effective in version 9.6.1 HotFix 2, Informatica adds the following improvements to address validation for addresses in Brazil:

• - The Address Validator transformation can add a third level of sub-building information to the Delivery Address Line and Formatted Address Line ports. The Brazil address system contains three levels of sub-building information.
• - The Address Validator transformation validates kilometer information on the Street Additional Info port.
Note: The Address Validator transformation uses a comma, and not a decimal point, in kilometer information for Brazil.

Data Processor Transformation

Validation Rules Editor

You can use the Validation Rules editor to create user-defined rules that validate XML data. If the data violates the rules, the action generates an XML validation report.

Parquet Input or Output

Use the New Transformation wizard to create a Data Processor transformation with Parquet input or output.

Create an XMap Variable for the XMap Source or Target

You can create an XMap variable to serve as the XMap source or target.

Metadata Manager

Cloudera Navigator Resources

Microsoft SQL Server Integration Services (SSIS) Resources

Embarcadero ERStudio Resources

PowerCenter Resources

PowerCenter Flat Files in the Impact Summary

PowerExchange Adapters

PowerExchange Adapters for Informatica

PowerExchange for Salesforce

Changed Data Capture

Effective in version 9.6.1 HotFix 2, you can configure PowerExchange for Salesforce to capture changed data from a Salesforce object that is replicateable and contains the CreatedDate and SysModstamp fields.

For more information, see the Informatica PowerExchange for Salesforce 9.6.1 HotFix 2 User Guide.

Salesforce API v31 and Multi-version Support

Effective in version 9.6.1 HotFix 2, PowerExchange for Salesforce supports the following features:

• - PowerExchange for Salesforce supports Salesforce API v31.
• - You can use PowerExchange for Salesforce to connect to Salesforce API v30 and v31.

For more information, see the Informatica PowerExchange for Salesforce 9.6.1 HotFix 2 User Guide.

PowerExchange for LinkedIn

PowerExchange for Facebook

PowerExchange for DataSift

• •You can retrieve data from the DataSift buffer.
• •You can pause and resume the Historics query.
• •You can configure the DataSift adapter to automatically reconnect if the connection is lost.

PowerExchange for Hive

• •You can use the user-defined functions in Informatica to transform the Binary data type in a Hive environment.
• •PowerExchange for Hive supports the Timestamp data type. The Timestamp data type format is YYYY-MM-DD HH:MM:SS.fffffffff. The Timestamp data type has a precision of 29 and a scale of 9.
• •PowerExchange for Hive supports the Date data type. The Date data type has a range of 0000-01-01 to 9999-12-31. The format is YYYY-MM-DD. The Date data type has a precision of 10 and a scale of 0.

PowerExchange Adapters for PowerCenter

PowerExchange for Vertica

• •You can create Vertica targets in the Target Analyzer.
• •You can use relational mode to read large volumes of data from a Vertica source. To read data in relational mode, you must create a Vertica relational connection and configure the session to use a relational reader.
• •You can use relational mode to update or delete data in a Vertica target. To write data in relational mode, you must create a Vertica relational connection and configure the session to use a relational writer.
• •When you use bulk mode to write large volumes of data to a Vertica target, you can configure the session to create a staging file. On UNIX operating systems, when you enable file staging, you can also compress the data in a GZIP format. By compressing the data, you can reduce the size of data that is transferred over the network and improve session performance.
• •You can run sessions on a grid to improve session performance.
• •The PowerCenter Integration Service can push transformation logic to Vertica sources and targets that use native drivers. For more information, see the Informatica PowerCenter 9.6.1 HotFix 2 Advanced Workflow Guide.

Workflows

Pushdown Optimization for Amazon Redshift

Support for Teradata Array Insert