What's Changed
Support Changes
This section describes the support changes in 10.2 HotFix 1.
Big Data Management Hadoop Distributions
The following table lists the supported Hadoop distribution versions and changes in Big Data Management 10.2 HotFix 1:
Hadoop Distribution | Supported Distribution Versions | 10.2 HotFix 1 Changes |
|---|
Amazon EMR | 5.8 | Dropped support for version 5.4. |
Azure HDInsight | 3.5.x 3.6.x | No change. |
Cloudera CDH | 5.10.x 5.11.x 5.12.x 5.13.x | Dropped support for version 5.9. |
Hortonworks HDP | 2.5x 2.6x | Dropped support for version 2.4. |
IBM BigInsights | Not supported. | Dropped support for IBM BigInsights. |
MapR | 5.2 MEP 3.0.x | Dropped support for version 5.2 MEP 2.0.x. |
Informatica big data products support a variety of Hadoop distributions. In each release, Informatica adds, defers, and drops support for Hadoop distribution versions. Informatica might reinstate support for deferred versions in a future release.
To see a list of the latest supported versions, see the Product Availability Matrix on the Informatica network:
https://network.informatica.com/community/informatica-network/product-availability-matricesIntelligent Streaming Hadoop Distributions
The following table lists the supported Hadoop distribution versions and changes in Intelligent Streaming 10.2 HotFix 1:
Distribution | Supported Versions | Changes Since 10.2 |
|---|
Amazon EMR | 5.8 | Dropped support for version 5.4. |
Cloudera CDH | 5.10 5.11 5.12 5.13 | No change. |
Hortonworks HDP | 2.5.x 2.6.x | No change. |
MapR | 5.2 MEP 3.0 | Dropped support for version 5.2 MEP 2.0. |
To see a list of the latest supported versions, see the Product Availability Matrix on the Informatica network: https://network.informatica.com/community/informatica-network/product-availability-matrices.
Application Services
This section describes changes to application services in version 10.2 HotFix 1.
Model Repository Service
Monitoring Model Repository Service
Effective in version 10.2 HotFix 1, configure a Model Repository Service as a monitoring Model Repository Service to monitor the statistics for ad hoc jobs, applications, logical data objects, SQL data services, web services, and workflows. Use separate database user accounts when you configure monitoring Model repository and Model repository.
Previously, you could use a Model Repository Service to store design-time and run-time objects in the Model repository.
For more information, see the "Model Repository Service" chapter in the Informatica 10.2 HotFix 1 Application Service Guide.
Big Data Management
This section describes the changes to Big Data Management in version 10.2 HotFix 1.
Precision and Scale on the Hive Engine
Effective in version 10.2 HotFix 1, the output of user-defined functions that perform multiplication on the Hive engine can have a maximum scale of 6 if the following conditions are true:
- •The difference between the precision and scale is greater than or equal to 32.
- •The resultant precision is greater than 38.
Previously, the scale could be as low as 0.
For more information, see the "Mappings in the Hadoop Environment" chapter in the Informatica Big Data Management 10.2 HotFix 1 User Guide.
Business Glossary
This section describes changes to Business Glossary in version 10.2 HotFix 1.
Alerts and Notifications
Effective in 10.2 HotFix 1, the Analyst tool displays glossary name in addition to the names of the sender and asset submitted for review. Previously, the Analyst tool displayed only the name of the sender and name of the asset that was submitted for review.
For more information, see the "Finding Glossary Content" chapter in the Informatica 10.2 HotFix 1 Business Glossary Guide.
Documentation
This section describes changes to guides in Informatica documentation in version 10.2 HotFix 1.
Informatica PowerCenter 10.2 HotFix 1 Repository Guide
Effective in version 10.2 HotFix 1, the Informatica PowerCenter 10.2 HotFix 1 Repository Guide includes appendices MX Views Reference and PowerCenter Reports Reference. The Informatica PowerCenter 10.2 HotFix 1 PowerCenter Reports Guide and the Informatica PowerCenter 10.2 HotFix 1 Using PowerCenter Reports Guide are moved into the Informatica PowerCenter 10.2 HotFix 1 Repository Guide as one appendix.
For more information, see the Informatica PowerCenter 10.2 HotFix 1 Repository Guide.
Informatica Development Platform
This section describes changes to Informatica Development Platform in version 10.2 HotFix 1.
Informatica Connector Toolkit
Effective in version 10.2 HotFix 1, you can use the Informatica Connector Toolkit to build connector for Informatica Intelligent Cloud Services by default. If you want to publish a connector developed using Informatica Connector Toolkit versions earlier than 10.2 HotFix 1, set YES as the value of the CTK_ADAPTER system environment variable. For example, CTK_ADAPTER =YES.
Previously, you could use the Informatica Connector Toolkit to build connector for Informatica Cloud Services.
For more information, see the Informatica Development Platform 10.2 HotFix 1 User Guide.
Informatica Transformations
This section describes the changes to the Informatica transformations in version 10.2 HotFix 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:
All Countries
Effective in version 10.2 HotFix 1, the Address Validator transformation uses version 5.13.0 of the Informatica Address Verification software engine. The engine enables the features that Informatica adds to the Address Validator transformation in version 10.2 HotFix 1.
Previously, the transformation used version 5.11.0 of the Informatica Address Verification software engine.
Parcel Centroid and Rooftop Geocodes
Effective June 2018, Informatica ceases to update the reference data files that contain Parcel Centroid and Rooftop geocode data, and Informatica ceases to provide the files to first-time users. Current reference data files for Parcel Centroid and Rooftop geocodes remain operational.
For more information, see the Informatica 10.2 HotFix 1 Developer Transformation Guide and the Informatica 10.2 HotFix 1 Address Validator Port Reference.
For comprehensive information about the updates to the Informatica Address Verification software engine from version 5.11.0 through version 5.13.0, see the Informatica Address Verification 5.13.0 Release Guide.
PowerCenter
This section describes changes to PowerCenter in version 10.2 HotFix 1.
Microsoft Analyst for Excel
Effective in version 10.2 HotFix 1, Informatica supports Mapping Analyst for Excel with Microsoft Excel 2016. Mapping Analyst for Excel includes an Excel add-in that you can use to configure mapping specifications in Microsoft Excel 2016.
Previously, Informatica supported Mapping Analyst for Excel with Microsoft Excel 2007 and Microsoft Excel 2010.
For more information about installing the add-in for Microsoft Excel 2016, see the Informatica PowerCenter 10.2 HotFix 1 Mapping Analyst for Excel Guide.
PowerExchange Adapters for PowerCenter
This section describes changes to PowerCenter adapters in version 10.2 HotFix 1.
PowerExchange for Amazon Redshift
Effective in version 10.2 HotFix 1, PowerExchange for Amazon Redshift has the following changes:
- •You can provide the number of files in the Number of Files per Batch field under the target session properties to calculate the number of the staging files for each batch.
Previously, the number of the staging files for each batch was calculated based on the values you provided in the Cluster Node Type and Number of Nodes in the Cluster fields under the connection properties.
- •The session log contains information about the individual time taken to upload data to the local staging area, upload data to Amazon S3 from the local staging area, and then upload data to an Amazon Redshift target by issuing copy command.
Previously, the session log contained only the total time taken to write data from source to target.
For more information, see the Informatica PowerExchange for Amazon Redshift 10.2 HotFix 1 User Guide for PowerCenter.
PowerExchange for Cassandra
Effective in version 10.2 HotFix 1, PowerExchange for Cassandra has the following changes:
- •The name and directory of the Informatica PowerExchange for Cassandra ODBC driver file has changed.
The following table lists the Cassandra ODBC driver file name and file directory based on Linux and Windows operating systems:
Operating System | Cassandra ODBC Driver File Name | File Directory |
|---|
Linux | libcassandraodbc_sb64.so | <Informatica installation directory>\tools\cassandra\lib\libcassandraodbc_sb64.so |
Windows | CassandraODBC_sb64.dll | <Informatica installation directory>\tools\cassandra\lib\CassandraODBC_sb64.dll |
On Linux operating systems, you must update the value of the Driver property to <Informatica installation directory>\tools\cassandra\lib\libcassandraodbc_sb64.so for the existing Cassandra data sources in the odbc.ini file.
On Windows, you must update the following properties in the Windows registry for the existing Cassandra data source name:
Driver=<Informatica installation directory>\tools\cassandra\lib\CassandraODBC_sb64.dll
Setup=<Informatica installation directory>\tools\cassandra\lib\CassandraODBC_sb64.dll
- •The new key name for Load Balancing Policy option is LoadBalancingPolicy.
Previously, the key name for Load Balancing Policy was COLoadBalancingPolicy.
- •The default values of the following Cassandra ODBC driver properties has changed:
Driver Property Name | Key Name | New Default Value |
|---|
Concurrent Requests | NumConcurrentRequests | 100 |
Insert Query Threads | NumInsertQueryThreads | 2 |
Iterations Per Insert Thread | NumIterationsPerInsertThread | 50 |
For more information, see the Informatica PowerExchange for Cassandra 10.2 HotFix 1 User Guide.
PowerExchange for Google BigQuery
Effective in version 10.2 HotFix 1, PowerExchange for Google BigQuery installs with the Informatica services.
Previously, PowerExchange for PowerExchange for Google BigQuery had a separate installer.
For more information, see the Informatica PowerExchange for Google BigQuery 10.2 HotFix 1 User Guide for PowerCenter.
PowerExchange for Salesforce
Effective in version 10.2 HotFix 1, the error messages that you encounter during a Salesforce session might differ because of a change in the Salesforce API.
For example, when you reconnect to Salesforce the following error message appears:
[ERROR] Reattempt the Salesforce request [getBatchInfo] due to the error [Server error returned in unknown format].
Previously, for the same scenario the following error message was displayed:
[ERROR] Reattempt the Salesforce request [getBatchInfo] due to the error [input stream can not be null].
PowerExchange for Salesforce Analytics
Effective in version 10.2 HotFix 1, PowerExchange for Salesforce Analytics installs with Informatica services.
Previously, PowerExchange for Salesforce Analytics had a separate installer.
For more information, see the Informatica PowerExchange for Salesforce Analytics 10.2 HotFix 1 User Guide for PowerCenter
PowerExchange for Snowflake
Effective in version 10.2 HotFix 1, PowerExchange for Snowflake installs with the Informatica services.
Previously, PowerExchange for PowerExchange for Snowflake had a separate installer.
For more information, see the Informatica PowerExchange for Snowflake 10.2 HotFix 1 User Guide for PowerCenter.
Reference Data
This section describes changes in reference data operations in version 10.2 HotFix 1.
Content Installer
Effective Spring 2018, Informatica no longer provides a Content Installer utility for accelerator files and reference data files. To add accelerator files or reference data files to an Informatica installation, extract and copy the files to the appropriate directories in the installation.
Previously, you might use the Content Installer to extract and copy the files to the Informatica directories.
For more information, see the Informatica 10.2 HotFix 1 Content Guide.
Properties Files in PowerCenter
Effective in version 10.2 HotFix 1, the upgrade process and the HotFix installation process maintain the contents of the reference data properties files from an earlier PowerCenter version. You do not need to edit any reference data properties file after you install the HotFix or upgrade to version 10.2 HotFix 1.
PowerCenter reads configuration information for reference data from the following properties files:
- •AD50.cfg. Contains properties for address reference data.
- •CLASSIFIER.properties. Contains properties for classifier models.
- •IDQTx.cfg. Contains properties for identity populations.
- •NER.properties. Contains properties for probabilistic models.
The HotFix installation or upgrade process writes backup versions of the properties files to the Informatica 10.2 HotFix 1 directories. The backup files are the default versions of the files and do not contain any value that you set in the earlier installation. Each backup file name ends with the extension .bak.
Previously, the upgrade operation renamed any reference data properties file that it found with the extension .bak. The upgrade operation also created default versions of any properties file that it renamed.
Note: Previously, if you installed a HotFix for an installation, so that the Informatica directory structure did not change, the installation process preserved the AD50.cfg file. The HotFix installation otherwise added the extension .bak to each reference data properties file that it found and created a default version of each file.
For more information, see the Informatica 10.2 HotFix 1 Content Guide.