New Features (9.6.1 HotFix 4)
This section describes new features in version 9.6.1 HotFix 4.
Command Line Programs
This section describes new commands in version 9.6.1 HotFix 4.
infacmd isp Commands
The following table describes a new infacmd isp command:
Command | Description |
|---|
ListDomainCiphers | Displays one or more of the following cipher suite lists used by the Informatica domain or a gateway node: - Black list
- User-specified list of cipher suites that the Informatica domain blocks.
- Default list
- List of cipher suites that Informatica supports by default.
- Effective list
- The list of cipher suites that the Informatica domain uses after you configure it with the infasetup updateDomainCiphers command. The effective list supports cipher suites in the default list and white list but blocks cipher suites in the black list.
- White list
- User-specified list of cipher suites that the Informatica domain can use in addition to the default list.
You can specify which lists that you want to display. |
For more information, see the "infacmd isp Command Reference" chapter Informatica 9.6.1 HotFix 4 Command Reference.
infasetup Commands
The following table describes new infasetup commands:
Command | Description |
|---|
ListDomainCiphers | Displays one or more of the following cipher suite lists used by the Informatica domain or a gateway node uses: - Black list
- User-specified list of cipher suites that the Informatica domain blocks.
- Default list
- List of cipher suites that Informatica supports by default.
- Effective list
- The list of cipher suites that the Informatica domain uses after you configure it with the infasetup updateDomainCiphers command. The effective list supports cipher suites in the default list and white list but blocks cipher suites in the black list.
- White list
- User-specified list of cipher suites that the Informatica domain can use.
You can specify which lists that you want to display. |
updateDomainCiphers | Updates the cipher suites that the Informatica domain can use with a new effective list. |
The following table describes updated options for infasetup commands:
Command | Description |
|---|
- - DefineDomain
- - DefineGatewayNode
- - DefineWorkerNode
- - UpdateGatewayNode
- - UpdateWorkerNode
| The commands contain the following new options: - - cipherWhiteList |-cwl
- - cipherWhiteListFile |-cwlf
- - cipherBlackList |-cbl
- - cipherBlackListFile |-cblf
Use these options to configure cipher suites for an Informatica domain that uses secure communication within the domain or secure connections to web application services. |
For more information, see the "infasetup Command Reference" chapter in the Informatica 9.6.1 HotFix 4 Command Reference.
Connectivity
This section describes new connectivity features in version 9.6.1 HotFix 4.
Schema Names in IBM DB2 Connections
Effective in version 9.6.1 HotFix 4, when you use an IBM DB2 connection to import a table in the Developer tool or the Analyst tool, you can specify one or more schema names from which you want to import the table. Use the ischemaname attribute in the metadata connection string URL to specify the schema names. Use the pipe (|) character to separate multiple schema names.
For example, enter the following syntax in the metadata connection string URL:
jdbc:informatica:db2://<host name>:<port>;DatabaseName=<database name>;ischemaname=<schema_name1>|<schema_name2>|<schema_name3>
For more information, see the Informatica 9.6.1 HotFix 4 Developer Tool Guide and Informatica 9.6.1 HotFix 4 Analyst Tool Guide.
Exception Management
This section describes new exception management features in version 9.6.1 HotFix 4.
- Search and replace data values by data type
- Effective in version 9.6.1 HotFix 4, you can configure the options in an exception task to search and replace data values based on the data type. You can configure the options to search and replace data in any column that contains date, string, or numeric data.
- When you specify a data type, the Analyst tool searches for the value that you enter in any column that uses the data type. You can find and replace any value that a string data column contains. You can perform case-sensitive searches on string data. You can search for a partial match or a complete match between the search value and the contents of a field in a string data column.
For more information, see the Exception Records chapter in the Informatica 9.6.1 HotFix 4 Exception Management Guide.
Informatica Domain
This section describes new features to Informatica Domain.
Domain Reports
Effective in version 9.6.1 HotFix 4, the License Management Report includes the consumed cores property. This property indicates the number of cores on the machine.
For more information about the License Management Report, see the "Domain Reports" chapter in the Informatica 9.6.1 HotFix 4 Administrator Guide.
Informatica Transformations
This section describes new Informatica transformation features in version 9.6.1 HotFix 4.
Address Validator Transformation
This section describes the new Address Validator transformation features.
The Address Validator transformation contains additional address functionality for the following countries:
- Ireland
- Effective in version 9.6.1 HotFix 4, you can return the eircode for an address in Ireland. An eircode is a seven-character code that uniquely identifies an Ireland address. The eircode system covers all residences, public buildings, and business premises and includes apartment addresses and addresses in rural townlands.
- To return the eircode for an address, select a Postcode port or a Postcode Complete port.
- France
- Effective in version 9.6.1 HotFix 4, address validation uses the Hexaligne 3 repository of the National Address Management Service to certify a France address to the SNA standard.
- The Hexaligne 3 data set contains additional information on delivery point addresses, including sub-building details such as building names and residence names.
- Germany
- Effective in version 9.6.1 HotFix 4, you can retrieve the three-digit street code part of the Frachtleitcode or Freight Code as an enrichment to a valid Germany addresses. The street code identifies the street within the address.
- To retrieve the street code as an enrichment to verified Germany addresses, select the Street Code DE port. Find the port in the DE Supplementary port group.
- Informatica adds the Street Code DE port in version 9.6.1 HotFix 4.
- South Korea
- Effective in version 9.6.1 HotFix 4, you can verify older, lot-based addresses and addresses with older, six-digit post codes in South Korea. You can verify and update addresses that use the current format, the older format, and a combination of the current and older formats. A current South Korea address has a street-based format and includes a five-digit post code. A non-current address has a lot-based format and includes a six-digit post code.
- To verify a South Korea address in an older format and to change the information to another format, use the Address Identifier KR ports. You update the address information in two stages. First, run the address validation mapping in batch or interactive mode and select the Address Identifier KR output port. Then, run the address validation mapping in address code lookup mode and select the Address Identifier KR input port. Find the Address Identifier KR input port in the Discrete port group. Find the Address Identifier KR output port in the KR Supplementary port group.
- To verify that the Address Validator transformation can read and write the address data, add the Supplementary KR Status port to the transformation.
- Informatica adds the Address Identifier KR ports, the Supplementary KR Status port, and the KR Supplementary port group in version 9.6.1 HotFix 4.
- Effective in version 9.6.1 HotFix 4, you can retrieve South Korea address data in the Hangul script and in a Latin script.
- United Kingdom
- Effective in version 9.6.1 HotFix 4, you can retrieve delivery point type data and organization key data for a United Kingdom address. The delivery point type is a single-character code that indicates whether the address points to a residence, a small organization, or a large organization. The organization key is an eight-digit code that the Royal Mail assigns to small organizations.
- To add the delivery point type to a United Kingdom address, use the Delivery Point Type GB port. To add the organization key to a United Kingdom address, use the Organization Key GB port. Find the ports in the UK Supplementary port group. To verify that the Address Validator transformation can read and write the data, add the Supplementary UK Status port to the transformation.
- Informatica adds the Delivery Point Type GB port and the Organization Key GB port in version 9.6.1 HotFix 4.
For more information, see the Informatica 9.6.1 HotFix 4 Address Validator Port Reference.
Metadata Manager
This section describes new Metadata Manager features in version 9.6.1 HotFix 4.
Application Properties
Effective in version 9.6.1 HotFix 4, you can configure new application properties in the Metadata Manager imm.properties file.
The following table describes new Metadata Manager application properties in imm.properties:
Property | Description |
|---|
xconnect.custom.failLoadOnErrorCount | Maximum number of errors that the Metadata Manager Service can encounter before the custom resource load fails. |
xconnect.io.print.batch.errors | Number of errors that the Metadata Manager Service writes to the in memory cache and to the mm.log file in one batch when you load a custom resource. |
For more information about the imm.properties file, see the "Metadata Manager Properties Files" appendix in the Informatica 9.6.1 HotFix 4 Metadata Manager Administrator Guide.
Migrate Business Glossary Audit Trail History and Links to Technical Metadata
Effective in version 9.6.1 HotFix 4, you can migrate audit trail history and links to technical metadata when you export business glossaries. You can import the audit trail history and links in the Analyst tool.
For more information, see the Informatica 9.6.1 HotFix 4 Upgrading from Version 9.5.1 Guide.
PowerExchange Adapters
This section describes new PowerExchange adapter features in version 9.6.1 HotFix 4.
PowerExchange Adapters for PowerCenter
This section describes new PowerCenter adapter features in version 9.6.1 HotFix 4.
PowerExchange for Greenplum
Effective in version 9.6.1 HotFix 4, you can configure Kerberos authentication for native Greenplum connections.
For more information, see the "Greenplum Sessions and Workflows" chapter in the Informatica 9.6.1 HotFix 4 PowerExchange for Greenplum User Guide for PowerCenter.
PowerExchange for Teradata Parallel Transporter API
Effective in version 9.6.1 HotFix 4, you can configure Kerberos authentication for native Teradata PT connections.
For more information, see the "Teradata PT API Sessions and Workflows" chapter in the Informatica 9.6.1 HotFix 4 PowerExchange for Teradata Parallel Transporter API User Guide for PowerCenter.
Security
This section describes new security features in version 9.6.1 HotFix 4.
Custom Cipher Suites
Effective in version 9.6.1 HotFix 4, you can customize the cipher suites that the Informatica domain uses for secure communication within the domain and secure connections to web application services. You can create a whitelist and blacklist to enable or block specific ciphersuites.
The Informatica domain uses an effective list of cipher suites that uses the cipher suites in the default and whitelists but blocks cipher suites in the blacklist.
For more information, see the "Domain Security" chapter in the Informatica 9.6.1 HotFix 4 Security Guide.