What's New

Command Line Programs

pmrep Commands

Informatica Analyst

Scorecards

Informatica Transformations

Address Validator Transformation

Australia

• •Census Collection District Code 2006
• •Geocoded National Address File Identifier
• •Greater Capital City Statistical Area 5-Digit
• •Greater Capital City Statistical Area Name
• •Level One Statistical Area 11-Digit
• •Level One Statistical Area 7-Digit
• •Level Two Statistical Area 9-Digit
• •Level Two Statistical Area 5-Digit
• •Level Two Statistical Area Name
• •Level Three Statistical Area 5-Digit
• •Level Three Statistical Area Name
• •Level Four Statistical Area 3-Digit
• •Level Four Statistical Area Name
• •Mesh Block 11-Digit 2011
• •Mesh Block 11-Digit 2016
• •State or Territory Code
• •State or Territory Name
• •Supplementary AU Status

Israel

Multilanguage support for Israel addresses

You can configure the Address Validator transformation to return an Israel address in the English language or the Hebrew language.

Use the Preferred Language property to select the preferred language for the addresses that the transformation returns.

The default language for Israel addresses is Hebrew. To return address information in Hebrew, set the Preferred Language property to DATABASE or ALTERNATIVE_1. To return the address information in English, set the property to ENGLISH or ALTERNATIVE_2.

Support for multiple character sets in Israel addresses

The Address Validator transformation can read and write Israel addresses in Hebrew and Latin character sets.

Use the Preferred Script property to select the preferred character set for the address data.

The default character set for Israel addresses is Hebrew. When you set the Preferred Script property to Latin or Latin-1, the transformation transliterates Hebrew address data into Latin characters.

United States

Additional information on undeliverable mail

You can configure the Address Validator transformation to return information on why the United States Postal Service does not deliver mail to an address that appears to be valid.

The United States Postal Service might not deliver mail to an address for one of the following reasons:

• - The address site is under construction.
• - The customer receives mail as a part of mail forwarding service.
• - The postal carrier returns the mail undelivered.

The United States Postal Service maintains a table of addresses that do not permit delivery. The table is called the No-Statistics table. To return a code that indicates why the United States Postal Service adds the address to the No-Statistics table, select the Delivery Sequence File Second Generation No Statistics Reason port. Find the port in the US Specific port group in the Basic model.

The transformation reads the No-Statistics table data from the USA5C131.MD database file.

Improved correction for addresses with trailing house number characters

You can configure the Address Validator transformation to identify a valid street address that includes a house number value with an unrecognized trailing alphabetic character. If the address can yield a valid delivery point without the trailing character, the transformation returns the value TA in the Delivery Point Validation Footnote ports.

Information on street addresses that forward mail to a Post Office Box

You can configure the Address Validator transformation to identify a street address for which the United States Postal Service redirects mail to a Post Office Box. To identify the address, select the Delivery Point Validation Throwback port. Find the port in the US Specific port group in the Basic model.

The transformation reads the throwback data from theUSA5C132.MD database file.

Information on addresses that cannot accept mail on one or more days of the week

You can configure the Address Validator transformation to identify United States addresses that do not receive mail on one or more days of the week.

To identify the addresses, use the Non-Delivery Days port. The port contains a seven-digit string that represents the days of the week from Sunday through Saturday. Each position in the string represents a different day.

Find the Non-Delivery Days port in the US Specific port group in the Basic model. To receive data on the Non-Delivery Days port, run the Address Validator transformation in certified mode. The transformation reads the port values from the USA5C129.MD and USA5C130.MD database files.

Metadata Manager

Cognos

• •Cognos SDK directory. Enter the Cognos SDK directory location.
• •Miscellaneous. Specify multiple miscellaneous options separated by commas.

Microstrategy

PowerCenter

Pushdown Optimization for PostgreSQL

PowerCenter Binary Functions

• •EBCDIC_ISO88591. Converts a binary value encoded in EBCDIC to a string value encoded in ISO-8859-1.
• •BINARY_COMPARE. Compares two binary values and returns TRUE (1) if they are the same and FALSE (0) if they are different.
• •BINARY_CONCAT. Concatenates two or more binary values together and returns the concatenated value.
• •BINARY_LENGTH. Returns the length of a binary value.
• •BINARY_SECTION. Returns a portion of a binary value.
• •DEC_HEX. Decodes a hex encoded value and returns a binary value with the binary representation of the data.
• •ENC_HEX. Encodes binary data to string data using hexadecimal encoding.
• •SHA256. Calculates the SHA-256 digest of the input value.

PowerExchange Adapters for PowerCenter

PowerExchange for Amazon Redshift

PowerExchange for Google BigQuery

• •You can configure a custom SQL query to configure a Google BigQuery source.
• •You can configure a SQL override to override the default SQL query used to extract data from the Google BigQuery source.
• •You can specify a quote character that defines the boundaries of text strings in a .csv file. You can configure parameters such as single quote or double quote.
• •You can configure full pushdown optimization to push the transformation logic to Google BigQuery when you use the ODBC connection type.
For information about the operators and functions that the PowerCenter Integration Service can push to Google BigQuery, see the Informatica PowerCenter 10.2 HotFix 2 Advanced Workflow Guide.

PowerExchange for Kafka

• •You can import a Kafka source or target definition in Avro format.
• •You can configure SSL configuration properties to securely connect to Kafka.
• •You can preview data of a Kafka source or target definition.

PowerExchange for Microsoft Azure SQL Data Warehouse V3

• •You can use custom queries when you read a source object.
• •You can override the source object and the source object schema in the source session properties. The source object and the source object schema defined in the source session properties take the precedence.
• •You can override the target object and the target object schema in the target session properties. The target object and the target object schema defined in the target session properties take the precedence.
• •You can create a mapping to read the real-time or changed data from a Change Data Capture (CDC) source and load data into Microsoft Azure SQL Data Warehouse. You must select Data Driven as the target operation to capture changed data. You can resume the extraction of changed data from the point of interruption when a mapping fails or is stopped before completing the session.
• • You can utilize the following pushdown functions when you use an ODBC connection to connect to Microsoft Azure SQL Data Warehouse:
• - Date_diff()
• - First()
• - Instr()
• - Last()
• - MD5()
• - ReplaceChr()
• - ReplaceStr()
• •To enhance the performance, you can compress staging files in the .gzip format when you write to a target object.

PowerExchange for Salesforce

• •You can use version 43.0, 44.0, and 45.0 of Salesforce API to create a Salesforce connection and access Salesforce objects.
• •You can enable primary key chunking for queries on a shared object that represents a sharing entry on the parent object. Primary key chunking is supported for shared objects only if the parent object is supported. For example, if you want to query on CaseHistory, primary key chunking must be supported for the parent object Case.
• •You can create assignment rules to reassign attributes in records when you insert, update, or upsert records for Lead and Case target objects using the standard API.
• •You can parameterize the Salesforce service URL for standard and OAuth connection.

PowerExchange for Snowflake

• •You can configure the PowerCenter Integration Service to write rejected records to a rejected file. If the file already exists, the PowerCenter Integration Service appends the rejected records to that file. If you do not specify the rejected file path, the PowerCenter Integration Service does not write the rejected records.
• •You can use an Update Strategy transformation in a mapping to insert, update, delete, or reject data in Snowflake targets. When you configure an Update Strategy transformation, the Treat Source Rows As session property is marked Data Driven by default.
• •You can use the SQL editor to create or edit the pre-SQL and post-SQL statements in the Snowflake source and target sessions.

Security

Kerberos Cross Realm Authentication