What's New
Application Services
This section describes new application service features in version 10.2 HotFix 1.
Model Repository Service
Git Version Control System
Effective in version 10.2 HotFix1, you can integrate the Model repository with the Git version control system. Git is a distributed version control system. When you check out and check in an object, a copy of the version is saved to the local repository and to the Git server. If the Git server goes down, the local repository retains all the versions of the object.
For more information, see the "Model Repository Service" chapter in the Informatica 10.2 HotFix 1 Application Service Guide.
Business Glossary
This section describes new Business Glossary features in version 10.2 HotFix 1.
Import Glossary Assets as Plain Text
Effective in 10.2 HotFix 1, you can import business glossary assets as plain text into the Analyst tool.
For more information about export and import of glossary assets, see the "Glossary Administration" chapter in the Informatica 10.2 HotFix 1 Business Glossary Guide.
Command Line Programs
This section describes new commands in version 10.2 HotFix 1.
infacmd isp Commands
The following table describes new infacmd isp commands:
Command | Description |
|---|
PingDomain | Pings a domain, service, domain gateway host, or node. |
ListPasswordRules | Lists the rules to set up complex passwords. |
ListWeakPasswordUsers | Lists the users with passwords that do not meet the password policy. |
For more information, see the "infacmd isp Command Reference" chapter in the Informatica 10.2 HotFix 1 Command Reference.
infacmd wfs Commands
The following table describes new infacmd wfs commands:
Command | Description |
|---|
pruneOldInstances | Deletes workflow process data from the workflow database. |
To delete the process data, you must have the Manage Service privilege on the domain.
For more information, see the "infacmd wfs Command Reference" chapter in the Informatica 10.2.1 Command Reference.
Connectivity
This section describes new connectivity features in version 10.2 HotFix 1.
Connectivity to Cloud Databases
Effective in version 10.2 HotFix 1, you can configure relational connections in Informatica Developer and PowerCenter to connect to Cloud databases.
You can configure the following connections:
- •Oracle connection to connect to Oracle Autonomous Data Warehouse Cloud version 18C
- •Oracle connection to connect to Oracle Database Cloud Service version 12C
- •Microsoft SQL Server connection to connect to Azure SQL Database
- •IBM DB2 connection to connect to DashDB
For more information, see the Informatica 10.2 HotFix 1 Installation and Configuration Guide.
Data Types
This section describes new data type features in 10.2 HotFix 1.
Microsoft SQL Server Data Types
Effective in version 10.2 HotFix 1, you can read or write the date data type when you use the Microsoft SQL Server connection in an Informatica mapping.
For more information, see the Data Type Reference appendix in the Informatica 10.2 HotFix 1 Developer Tool Guide.
Installer
This section describes new Installer feature in version 10.2 HotFix 1.
Docker Utility
Effective in version 10.2 HotFix 1, you can use the Informatica PowerCenter Docker utility to create the Informatica domain services. You can build the Informatica docker image with base operating system and Informatica binaries and run the existing docker image to create the Informatica domain within a container.
For more information about installing Informatica PowerCenter Docker utility to create the Informatica domain services, see
https://kb.informatica.com/h2l/HowTo%20Library/1/1213-InstallInformaticaUsingDockerUtility-H2L.pdf.
Informatica Transformations
This section describes new features in Informatica transformations in version 10.2 HotFix 1.
Address Validator Transformation
This section describes new Address Validator transformation features.
The Address Validator transformation contains additional address functionality for the following countries:
All Countries
Effective in version 10.2 HotFix 1, the Address Validator transformation supports single-line address verification in every country for which Informatica provides reference address data.
In earlier versions, the transformation supported single-line address verification for 26 countries.
To verify a single-line address, enter the address in the Complete Address port. If the address identifies a country for which the default preferred script is not a Latin or Western script, use the default Preferred Script property on the transformation with the address.
Austria, Germany, and Switzerland
Effective in version 10.2 HotFix 1, the Address Validator transformation supports the uppercase character ẞ in Austria, Germany, and Switzerland addresses.
The transformation supports the character ẞ in the following ways:
- •If you set the Casing property to UPPER, the transformation returns the German character ß as ẞ. If you set the Casing property to LOWER, the transformation returns the German character ẞ as ß.
- •The transformation treats ẞ and ß as equally valid characters in an address. In reference data matches, the transformation can identify a perfect match when the same values contain either ẞ or ß.
- •The transformation treats ẞ and ss as equally valid characters in an address. In reference data matches, the transformation can identify a standardized match when the same values contain either ẞ or ss.
- •If you set the Preferred Script property to ASCII_SIMPLIFIED, the transformation returns the character ẞ as S.
- •If you set the Preferred Script property to ASCII_EXTENDED, the transformation returns the character ẞ as SS.
Bolivia
Effective in version 10.2 HotFix 1, the Address Validator transformation improves the parsing and validation of Bolivia addresses. Additionally, Informatica updates the reference data for Bolivia.
The transformation also includes the following improvements for Bolivia:
- •Address validation to street level.
- •Geocoordinates at street mid-point level for addresses in major cities.
Canada
Informatica introduces the following features and enhancements for Canada:
- Support for the Global Preferred Descriptor property in Canada Addresses
Effective in version 10.2 HotFix 1, you can configure the transformation to return the short or long form of an element descriptor.
Address Verification can return the short or long form of the following descriptors:
- - Street descriptors
- - Directional values
- - Building descriptors
- - Sub-building descriptors
To specify the output format for the descriptors, configure the Global Preferred Descriptor property on the transformation. The property applies to English-language and French-language descriptors. By default, the transformation returns the descriptor in the format that the reference data specifies. If you select the PRESERVE INPUT option on the property, the Preferred Language property takes precedence over the Global Preferred Descriptor property.
- Support for CH and CHAMBER as Sub-Building Descriptors
- Effective in version 10.2 HotFix 1, Address Validator transformation recognizes CH and CHAMBER as sub-building descriptors in Canada addresses.
Colombia
Effective in version 10.2 HotFix1, the Address Validator transformation improves the processing of street data in Colombia addresses. Additionally, Informatica updates the reference data for Colombia.
The Address Validator transformation validates an address in Colombia to house number level. The transformation can verify a Colombia address that includes information for the street on which the house is located and also for the nearest cross street to the house.
For example, the transformation can verify the following addresses:
AVENIDA 31 65 29 APTO 1626
AVENIDA 31 DIAGONAL 65 29 APTO 1626
Consider the following guidelines for Colombia addresses:
- •The Address Validator transformation can verify the address with and without the cross street descriptor DIAGONAL.
- •The transformation can verify the address with and without a dash symbol between the cross street number and the house number. The transformation does not include a dash symbol in this position in the output address.
- •The transformation can recognize the # symbol before the cross street number in an input address. The transformation recognizes the address as a reference data match and not a correction.
For example, address validation recognizes the following input address as a reference data match and omits the # symbol from the verified output address:
AVENIDA 31 #65 29 APTO 1626
France
Effective in version 10.2 HotFix 1, Informatica introduces the following improvements for France addresses:
- •Informatica improves the supplementary reference data for France.
- •The Address Validator transformation assigns addresses to IRIS units in France with greater accuracy. The transformation uses the house number in the address to verify the IRIS unit to which the address belongs. The use of house numbers can improve the assignment accuracy when the address lies close to the border between different units.
India
Effective in version 10.2 HotFix 1, the Address Validator transformation validates an address in India to house number level.
Peru
Effective in version 10.2 HotFix 1, the Address Validator transformation validates a Peru address to house number level. Additionally, Informatica updates the reference data for Peru.
South Africa
Effective in version 10.2 HotFix 1, the Address Validator transformation improves the parsing and verification of delivery service descriptors in South Africa addresses.
The transformation improves the parsing and verification of the delivery service descriptors in the following ways:
- •Address Verification recognizes Private Bag, Cluster Box, Post Office Box, and Postnet Suite as different types of delivery service. Address Verification does not standardize one delivery service descriptor to another. For example, Address Verification does not standardize Postnet Suite to Post Office Box.
- •Address Verification parses Postnet Box as a non-standard delivery service descriptor and corrects Postnet Box to the valid descriptor Postnet Suite.
- •Address Verification does not standardize the sub-building descriptor Flat to Fl.
South Korea
Effective in version 10.2 HotFix 1, the Address Validator transformation introduces the following features and enhancements for South Korea:
- •The South Korea address reference data includes building information. The transformation can read, verify, and correct building information in a South Korea address.
- •The transformation returns all of the current addresses at a property that an older address represents. The older address might represent a single current address or it might represent multiple addresses, for example if multiple residences occupy the site of the property.
To return the current addresses, first find the address ID for the older property. When you submit the address ID with the final character A in address code lookup mode, the transformation returns all current addresses that match the address ID.
Note: The Address Validator transformation uses the Max Result Count property to determine the maximum number of addresses to return for the address ID that you enter. The Count Overflow property indicates whether the database contains additional addresses for the address ID.
Sweden
Effective in version 10.2 HotFix 1, the Address Validator transformation improves the verification of street names in Sweden addresses.
The transformation improves the verification of street names in the following ways:
- •The transformation can recognize a street name that ends in the character G as an alias of the same name with the final characters GATAN.
- •The transformation can recognize a street name that ends in the character V as an alias of the same name with the final characters VÄGEN.
- •The Address Validator transformation can recognize and correct a street name with an incorrect descriptor when either the long form or the short form of the descriptor is used.
For example, The transformation can correct RUNIUSV or RUNIUSVÄGEN to RUNIUSGATAN in the following address:
RUNIUSGATAN 7
SE-112 55 STOCKHOLM
Thailand
Effective in version 10.2 HotFix 1, the Address Validator transformation introduces the following features and enhancements for Thailand:
- Improvements to Thailand Addresses
The transformation improves the parsing and validation of Thailand addresses in a Latin script.
Additionally, the transformation validates an address to house number level.
- Native Support for Thailand Addresses
The Address Validator transformation can read and write Thailand addresses in native Thai and Latin scripts. Informatica updates the reference data for Thailand and adds reference data in the native Thai script.
Informatica provides separate reference databases for Thailand addresses in each script. To verify addresses in the native Thai script, install the native Thai databases. To verify addresses in a Latin script, install the Latin databases.
Note: If you verify Thailand addresses, do not install both database types. Accept the default option for the Preferred Script property.
United Arab Emirates
Effective in version 10.2 HotFix 1, the Address Validator transformation verifies street names in United Arab Emirates addresses. To verify street names in United Arab Emirates, install the current reference address databases for the United Arab Emirates.
United Kingdom
Effective in version 10.2 HotFix 1, the Address Validator transformation can return a United Kingdom territory name.
The transformation returns the territory name in the Country_2 element and returns the country name in the Country_1 element. You can configure an output address with both elements, or you can omit the Country_1 element if you post mail within the United Kingdom. The territory name appears above the postcode in a United Kingdom address on an envelope or label.
To return the territory name, install the current United Kingdom reference data.
United States
Effective in version 10.2 HotFix 1, the Address Validator transformation can recognize up to three sub-building levels in a United States address.
In compliance with the United States Postal Service requirements, the transformation matches the information in a single sub-building element with the reference data. If the Sub-building_1 information does not match, the transformation compares the Sub-building_2 information. If the Sub-building_2 information does not match, the transformation compares the Sub-building_3 information. The transformation copies the unmatched sub-building information from the input address to the output address.
For comprehensive information about the features and operations of the address verification software engine version that Informatica embeds in version 10.2 HotFix 1 see the Informatica Address Verification 5.13.0 Developer Guide.
Metadata Manager
This section describes new Metadata Manager features in version 10.2 HotFix 1.
SAML Authentication for Metadata Manager
Effective in version 10.2 HotFix 1, Metadata Manager supports Security Assertion Markup Language (SAML)-based single sign-on. SAML-based single sign-on authenticates users against account credentials stored in Microsoft Active Directory. Accounts are imported from Active Directory into a security domain within the Informatica domain.
For information, see the "SAML Authentication for Informatica Web Applications" chapter in the Informatica 10.2 HotFix 1 Security Guide.
Skip Lineage During Metadata Manager Repository Backup or Restore Operations
Effective in version 10.2 HotFix 1, use the [<-sl|--skipLineage> skipLineage] option in the backupRepository and restoreRepository command to skip lineage during Metadata Manager repository back up and restore operations.
For information, see the Informatica 10.2 HotFix 1 Metadata Manager Command Reference Guide.
PowerCenter
This section describes new PowerCenter features in version 10.2 HotFix 1.
Pushdown Optimization for SAP HANA
Effective in version 10.2 HotFix 1, when the connection type is ODBC, you can select the ODBC provider sub-type as SAP HANA to push transformation logic to SAP HANA. You can configure source-side, target-side, or full pushdown optimization to push the transformation logic to SAP HANA.
For more information, see the Informatica PowerCenter 10.2 HotFix 1 Advanced Workflow Guide.
Pushdown Optimization for Snowflake
Effective in version 10.2 HotFix 1, when the connection type is ODBC, you can configure source-side or full pushdown optimization to push the transformation logic to Snowflake.
For information, see the Informatica PowerCenter 10.2 HotFix 1 Advanced Workflow Guide.
PowerExchange Adapters for Informatica
This section describes new Informatica adapter features in version 10.2 HotFix 1.
PowerExchange for Microsoft Azure Blob Storage
Effective in version 10.2 HotFix 1, PowerExchange for Microsoft Azure Blob Storage includes the following functionality:
- •You can run mappings on the Spark engine.
- •You can use the file port to store the file name from which the Data Integration Service reads the data at run-time.
- •You can read and write .csv, Avro, and Parquet files when you run a mapping in the native environment.
- •You can read a directory when you run a mapping in the native environment.
- •You can generate or skip header rows when you run a mapping in the native environment. On the Spark engine, the header row is created by default.
- •You can append an existing blob. The append operation is applicable to only to the .csv files in the native environment.
- •You can override the blob or container name. In the Blob Container Override field, specify the container name or sub-folders in the root container with the absolute path.
- •You can read and write .csv files compressed in the gzip format in the native environment.
For more information, see the Informatica PowerExchange for Microsoft Azure Blob Storage 10.2 HotFix 1 User Guide.
PowerExchange for Microsoft Azure SQL Data Warehouse
Effective in version 10.2 HotFix 1, PowerExchange for Microsoft Azure SQL Data Warehouse includes the following features:
- •You can configure key range partitioning when you read data from Microsoft Azure SQL Data Warehouse objects.
- •You can override the SQL query and define constraints when you read data from a Microsoft Azure SQL Data Warehouse object.
- •You can configure pre-SQL and post-SQL queries for source and target objects in a mapping.
- •You can configure the native expression filter for the source data object operation.
- •You can perform update, upsert, and delete operations against Microsoft Azure SQL Data Warehouse tables.
- •You can configure an uncached lookup operation in the native environment.
For more information, see the Informatica PowerExchange for Microsoft Azure SQL Data Warehouse 10.2 HotFix 1 User Guide.
PowerExchange for Netezza
Effective in version 10.2 HotFix 1, you can configure dynamic mappings to change Netezza sources and targets at run time based on parameters and rules that you define.
When you configure dynamic mappings, you can also create or replace the target at run time. You can select the Create or replace table at run time option in the advanced properties of the Netezza data object write operation.
PowerExchange for Teradata Parallel Transporter API
Effective in version 10.2 HotFix 1, you can configure dynamic mappings to change Teradata sources and targets at run time based on parameters and rules that you define.
When you configure dynamic mappings, you can also create or replace the Teradata target at run time. You can select the Create or replace table at run time option in the advanced properties of the Teradata data object write operation.
PowerExchange Adapters for PowerCenter
This section describes new PowerCenter adapter features in version 10.2 HotFix 1.
PowerExchange for Amazon Redshift
Effective in version 10.2 HotFix 1, PowerExchange for Amazon Redshift includes the following new features:
- •In addition to the existing regions, you can also read data from or write data to the AWS GovCloud region.
- •You can specify the part size of an object to download the object from Amazon S3 in multiple parts.
- •You can encrypt data while fetching the file from Amazon Redshift using the AWS-managed encryption keys or AWS KMS-managed customer master key for server-side encryption.
- •You can provide the number of files to calculate the number of the staging files for each batch. If you do not provide the number of files, PowerExchange for Amazon Redshift calculates the number of the staging files.
- •You can use the TRUNCATECOLUMNS option in the copy command to truncate the data of the VARCHAR and CHAR data types column before writing data to the target.
- •PowerExchange for Amazon Redshift supports version 11 and 12 of SuSe Linux Enterprise Server operating system.
For more information, see the Informatica PowerExchange for Amazon Redshift 10.2 HotFix 1 User Guide for PowerCenter.
PowerExchange for Amazon S3
Effective in version 10.2 HotFix 1, PowerExchange for Amazon S3 includes the following new features:
- •In addition to the existing regions, you can also read data from or write data to the AWS GovCloud region.
- •You can specify the line that you want to use as the header when you read data from Amazon S3. You can specify the line number in the Header Line Number property under the source session properties.
- •You can specify the line number from where you want the PowerCenter Integration Service to read data. You can configure the Read Data From Line property under the source session properties.
- •You can specify an asterisk (*) wildcard in the file name to fetch files from the Amazon S3 bucket. You can specify the asterisk (*) wildcard to fetch all the files or only the files that match the name pattern.
- •You can add a single or multiple tags to the objects stored on the Amazon S3 bucket to categorize the objects. Each tag contains a key value pair. You can either enter the key value pairs or specify the absolute file path that contains the key value pairs.
- •You can specify the part size of an object to download the object from Amazon S3 in multiple parts.
- •You can configure partitioning for Amazon S3 sources. Partitioning optimizes the mapping performance at run time when you read data from Amazon S3 sources.
- •PowerExchange for Amazon S3 supports version 11 and 12 of SuSe Linux Enterprise Server operating system.
For more information, see the Informatica PowerExchange for Amazon S3 10.2 HotFix 1 User Guide for PowerCenter.
PowerExchange for Cassandra
Effective in version 10.2 HotFix 1, the Informatica Cassandra ODBC driver supports asynchronous write.
To enable asynchronous write on a Linux operating system, you must add the EnableAsynchronousWrites key name in the odbc.ini file and set the value to 1.
To enable asynchronous write on a Windows operating system, you must add the EnableAsynchronousWrites property in the Windows registry for the Cassandra ODBC data source name and set the value as 1.
For more information, see the Informatica PowerExchange for Cassandra 10.2 HotFix 1 User Guide for PowerCenter.
PowerExchange for Microsoft Dynamics CRM
Effective in version 10.2 HotFix 1, PowerExchange for Microsoft Dynamics CRM includes the following new features:
- •You can select either Discovery Service or Organization Service as a service type for passport authentication in the Microsoft Dynamics CRM run-time connection.
- •You can configure an alternate key in update, upsert, and delete operations.
- •You can specify an alternate key as a reference for Lookup, Customer, Owner, and PartyList data types.
For more information, see the Informatica PowerExchange for Microsoft Dynamics CRM 10.2 HotFix 1 User Guide for PowerCenter.
PowerExchange for Salesforce
Effective in version 10.2 HotFix 1, PowerExchange for Salesforce includes the following new features:
- •You can use version 42.0 of Salesforce API to create a Salesforce connection and access Salesforce objects.
- •You can configure OAuth for Salesforce connections.
For more information, see theInformatica PowerExchange for Salesforce 10.2 HotFix 1 User Guide for PowerCenter.
PowerExchange for SAP NetWeaver
Effective in version 10.2 HotFix 1, PowerExchange for SAP NetWeaver includes the following new features:
- Connection resiliency support for business content integration mappings
You can configure the following connection resiliency parameters in the listener session of business content integration mappings:
- - Number of Retries for Connection Resiliency. Defines the number of connection retries the PowerCenter Integration Service must attempt in the event of an unsuccessful connection with SAP.
- - Delay between Retries for Connection Resiliency. Defines the time interval in seconds between the connection retries.
- New SAP data types support
You can use the following new SAP data types based on the integration method you use:
Data Type | Data Integration using the ABAP Program (Table Reader and Ttable Writer) | Data Integration using BAPI/RFC Functions | IDoc Integration using ALE |
|---|
INT8 | Supported | Not supported | Not supported |
DF16_DEC | Supported | Supported | Not supported |
DF34_DEC | Supported | Supported | Not supported |
DF16_DEC | Supported | Supported | Not supported |
DF34_DEC | Supported | Supported | Not supported |
DF16_RAW | Supported | Supported | Not supported |
DF34_RAW | Supported | Supported | Not supported |
RAWSTRING | Supported | Not supported | Supported |
STRING | Supported | Supported | Supported |
SSTRING | Supported | Supported | Not supported |
For more information, see the Informatica PowerExchange for SAP NetWeaver 10.2 HotFix 1 User Guide for PowerCenter.
PowerExchange for Snowflake
Effective in version 10.2 HotFix 1, PowerExchange for Snowflake includes the following new features:
- •You can configure a custom SQL query to configure a Snowflake source.
- •You can override the database and schema name when you create temporary tables in the Snowflake staging database. You must add the database and schema name that you want to override in the JDBC URL parameters of the Snowflake connection.
- •You can override the imported Snowflake source table name by specifying the table name in the Snowflake session properties. You can also configure a SQL override to override the default SQL query used to extract data from the Snowflake source.
- •You can override the Snowflake target table name by specifying the table name in the Snowflake target session properties.
- •You can configure source-side or full pushdown optimization to push the transformation logic to Snowflake when you use the ODBC connection type. For information about the operators and functions that the PowerCenter Integration Service can push to Snowflake, see the Informatica PowerCenter 10.2 HotFix 1 Advanced Workflow Guide.
- •You can join multiple Snowflake source tables by specifying a join condition.
- •You can configure an unconnected lookup transformation for the source qualifier in a mapping.
- •You can configure pass-through partitioning for a Snowflake session. After you add the number of partitions, you can specify an SQL override or a filter override condition for each of the partitions.
- •You can configure the HTTP proxy server authentication settings at design time or at run time to read data from or write data to Snowflake.
- •You can configure Okta SSO authentication by specifying the authentication details in the JDBC URL parameters of the Snowflake connection.
- •You can read data from and write data to Snowflake that is enabled for staging data in Azure or Amazon.
For more information, see the Informatica PowerExchange for Snowflake 10.2 HotFix 1 User Guide for PowerCenter.
PowerExchange for Teradata Parallel Transporter API
Effective in version 10.2 HotFix 1, when you use the Load operator, you can set the maximum buffer size in kilobytes that the Teradata PT API uses for writing data. You can set the maximum buffer size value in the Teradata target session properties.
Security
This section describes new security features in version 10.2 HotFix 1.
Security - Password Complexity
Effective in version 10.2 HotFix 1, you can enable password complexity to validate the password strength. By default this option is disabled.
For more information, see the "Security Management in Informatica Administrator" chapter in the Informatica 10.2 HotFix 1 Security Guide.