Changes (9.6.1 HotFix 2)
This section describes changes in version 9.6.1 HotFix 2.
Connectivity
This section describes changes to connectivity in version 9.6.1 HotFix 2.
Sybase IQ External Loader Connection Attributes
Effective in version 9.6.1 HotFix 2, PowerCenter supports connectivity to Sybase IQ database version 16.0 by default. Informatica dropped support for the following Sybase IQ external loader connection attributes because Sybase IQ does not support these connection attributes from version 16.0:
If you upgrade to version 9.6.1 HotFix 2 and want to use the block factor and block size connection attributes while connecting to a Sybase IQ database version that is earlier than 16.0, configure the SybaseIQPre16VersionSupport custom property and set its value to Yes.
Informatica Analyst
The following changes apply to Informatica Analyst:
- •Effective in 9.6.1 HotFix 2, the Analyst tool displays the full name of the user who owns or most recently updated a Model repository object. The full name appears in any location that identifies the user, for example in the asset details in the library workspace.
Previously, the Analyst tool displayed the login name of the user in the library workspace and in other locations.
To view the full name, the login name, and any email address stored for the user, place the cursor on the full name.
- •Effective in 9.6.1 HotFix 2, you can select the full name of the user in filter operations in the Analyst tool.
Previously, you selected the login name of the user in filter operations in the Analyst tool.
Informatica Transformations
This section describes changes to Informatica transformations in version 9.6.1 HotFix 2.
Address Validator Transformation
The following changes apply to the Address Validator Transformation:
- •Effective in version 9.6.1 HotFix 2, the Address Validator transformation can return county information and sub-building information when you validate United States address data in suggestion list mode. The transformation returns the county information on a Province 2 port. The transformation returns the sub-building information on a sub-building port.
The transformation continues to return county information and sub-building information when you validate the address data in batch mode, certified mode, and interactive mode.
Previously, the transformation did not return the information for United States address data in suggestion list mode.
- •Effective in version 9.6.1 HotFix 2, the National Institute of Statistics and Economic Studies Code port name changes to INSEE 9-Code. You do not need to update the configuration of an Address Validator transformation that uses the National Institute of Statistics and Economic Studies Code port.
- •Effective in version 9.6.1 HotFix 2, all Locality Complete ports, Locality Name ports, and Locality Preferred Name ports have a precision of 100.
Previously, the ports had a precision of 50.
Data Processor Transformation
Effective in version 9.6.1 HotFix 2, a Data Processor transformation that converts hierarchical input to relational output has significantly improved performance.
To further increase performance for XML input, you can clear the Normalize XML Input setting in the Settings tab when XML input is already normalized.
Decision Transformation
Effective in version 9.6.1 HotFix 2, you can set a maximum precision of 1024 on the REPLACESTR() function in the Decision transformation.
Previously, you set a maximum precision of 512 on the function.
Metadata Manager
This section describes changes to Metadata Manager in version 9.6.1 HotFix 2.
Business Glossary Resources
Effective in version 9.6.1 HotFix 2, business glossary resources have the following changes:
- •When you load a business glossary resource, Metadata Manager extracts published business terms in unpublished categories. Previously, Metadata Manager did not extract a published business term when the category to which the term belongs was unpublished.
- •Metadata Manager no longer displays audit trail information for business terms and categories. To view audit trail information for business terms or categories, view the object history in the Analyst tool.
Metadata Manager Command Line Programs
Effective in version 9.6.1 HotFix 2, Metadata Manager repository commands have behavior changes or changed command options. Additionally, some commands are moved from the mmcmd command line program to the mmRepoCmd command line program.
The following mmRepoCmd command has changed behavior:
- restoreRepository
- Restores Metadata Manager repository contents from a back-up file. You can restore repository contents to an empty repository. Previously, you had to create repository contents before you could run this command. The options for this command are not changed.
The following commands are moved from mmcmd to mmRepoCmd:
- createRepository
Creates the Metadata Manager warehouse tables and imports models for metadata sources into the Metadata Manager repository. You must enable the Metadata Manager Service before you can run this command.
You can run this command from an mmRepoCmd instance that is installed with the Informatica services, Informatica client, or Informatica utilities. Previously, you could run this command from an mmRepoCmd instance that was installed with the Informatica services.
The options for this command are changed. You enter command options for the Metadata Manager user instead of for the domain user. Also, you no longer have to enter command options for the PowerCenter repository. The Metadata Manager Service process restores the PowerCenter repository content when you start the Metadata Manager service.
The following table describes new command options:
Option | Description |
|---|
-url | Host name and port number of the Metadata Manager Service that runs the Metadata Manager application. |
--user | Metadata Manager user name. |
--encryptedPassword | Encrypted password flag for the Metadata Manager user password. |
--password | Password for the Metadata Manager user. |
--namespace | Name of the security domain to which the Metadata Manager user belongs. |
The following table describes command options that are removed:
Option | Description |
|---|
--securityDomain | Name of the security domain to which the Informatica domain user belongs. |
--domainUser | User name used to connect to the Informatica domain. |
--domainPassword | Password for the Informatica domain user. |
-pcRepositoryName | Name of the PowerCenter repository that contains the metadata objects used to load metadata into the Metadata Manager warehouse. |
-pcRepositoryUser | User account for the PowerCenter repository. Use the repository user account you configured for the Repository Service. |
-pcRepositoryNamespace | Name of the security domain to which the PowerCenter repository user belongs. |
-pcRepositoryPassword | Password for the PowerCenter repository user. |
-restorePCRepository | Restore the repository back-up file for the PowerCenter repository to create the objects used by Metadata Manager in the PowerCenter repository database. |
The following table describes changed command options:
Option | Description |
|---|
--keyTab | This option specifies the path and file name of the keytab file for the Metadata Manager user instead of for the domain user. |
- deleteRepository
Deletes Metadata Manager repository content, including all metadata and repository database tables.
You can run this command from an mmRepoCmd instance that is installed with the Informatica services, Informatica client, or Informatica utilities. Previously, you could run this command from an mmRepoCmd instance that was installed with the Informatica services.
The options for this command are changed. You enter command options for the Metadata Manager user instead of for the domain user.
The following table describes new command options:
Option | Description |
|---|
-url | Host name and port number of the Metadata Manager Service that runs the Metadata Manager application. |
--user | Metadata Manager user name. |
--encryptedPassword | Encrypted password flag for the Metadata Manager user password. |
--password | Password for the Metadata Manager user. |
--namespace | Name of the security domain to which the Metadata Manager user belongs. |
The following table describes command options that are removed:
Option | Description |
|---|
--securityDomain | Name of the security domain to which the Informatica domain user belongs. |
--domainUser | User name used to connect to the Informatica domain. |
--domainPassword | Password for the Informatica domain user. |
The following table describes changed command options:
Option | Description |
|---|
--keyTab | This option specifies the path and file name of the keytab file for the Metadata Manager user instead of for the domain user. |
- restorePCRepository
- Restores a PowerCenter repository back-up file that contains Metadata Manager objects to the PowerCenter repository database. You must run this command from an mmRepoCmd instance that is installed with the Informatica services. The options for this command are not changed.
Metadata Manager Privileges
Effective in version 9.6.1 HotFix 2, the privileges that you need to create or restore the Metadata Manager repository are changed.
To create or restore the Metadata Manager repository, you must belong to the default Administrator group. Previously, you needed the Manage Services privilege with permission on the Metadata Manager Service.
Metadata Manager Product Name
Effective in version 9.6.1 HotFix 2, the product name that appears in the Metadata Manager web application is changed to Metadata Manager. Previously, the product name was Metadata Manager & Business Glossary.