Skip navigation
1 2 Previous Next

PowerCenter

23 posts

What are we announcing?

Informatica 10.2.0 HotFix1 PowerCenter zLinux support

 

Who would benefit from this release?

This release is the latest version of 10.2 for PowerCenter customers running zLinux

 

What’s in this release?

PowerCenter zLinux support on:

  • Operating system - Red Hat Enterprise Linux 6.9
  • Informatica Domain Database - Oracle 12cR2
  • PowerCenter Repository Support - Oracle 12cR2
  • PowerCenter Connectivity - PWX relational - Oracle, IBM DB2 and MS SQL Server
  • IDS Web Services
  • IBM z Series JDK - 8.0.5.20 

 

Please refer to the 10.2.0 HF1 Product Availability Matrix (PAM) for Informatica Platform for zLinux support details.

 

10.2.0 HotFix 1 Product Availability Matrix (PAM)

 

Informatica 10.2 HotFix 1 Release Notes

 

You can download the Hotfixes from here.

The Informatica Platform is a set of data services and information solutions powered by a state-of-the-art data management engine.   The end of support for the Informatica Platform includes the following products:

 

  • PowerCenter
  • Metadata Manager and Business Glossary
  • PowerExchange (PWX)
  • Data Quality (DQ)
  • Data Transformation (B2B DT)
  • Big Data Management (BDM)
  • Data Integration HUB (DIH)
  • B2B Data Exchange (DX) without OEM Cleo MFT products (see Informatica Product Lifecycle Guide for more details and DX end of life)

 

Support for all Informatica Platform products with versions 9.0.x, 9.1, 9.5.x, and 9.6.x will end on the following dates:

 

Version

Release Date

Minimum Support Period

End of Support

Extended Support*

Sustaining Support*

9.6.x

Jan 2014

31 Jan 2018

31 Mar 2018

31 Mar 2019

31 Mar 2021

9.5.x

Jun 2012

30 Jun 2016

31 Jul 2017

31 Jul 2018

Not Available

9.1

Mar 2011

31 Mar 2015

31 Jan 2017

31 Jan 2018

Not Available

9.0.x

Dec 2009

31 Dec 2013

31 Jan 2017

31 Jan 2018

Not Available

* Extended and Sustaining Support are available at an additional charge; Sustaining Support is not available for all product releases. For further information please contact: dlicare@informatica.com.

 

For more information on product lifecycle, extended support policy, and end of life details of various Informatica products, view the Informatica Product Lifecycle Guide.

This is a feature release of DVO with new capabilities focused on:

 

  • Security
  • Data Connectivity
  • Enhanced Test Generation
  • Improved Usability
  • Support for PowerCenter 9.6

 

New Features and Enhancements in DVO 9.6 include:

 

Security

 

  • User Authentication in Kerberos domain
  • Support for Oracle ASO for DVO repository
  • Encrypt user passwords in DVOcmd

 

Connectivity

 

  • Native PowerExchange support for Mainframe sources
    • IMS, ADABAS, VSAM, DB2 AS/400, MF flatfiles
  • Enhancements to SAP R/3 support to allow reuse of existing ABAP

 

Enhanced Test Generation

 

  • Aggregate View – ability to aggregate any types of data and use in tests
  • Full table/column metadata in spreadsheet exports

 

Usability

 

  • Enhancements to Error Row display for both string/text and numeric values
  • Override SQL View connections when used in Single Tables, Table Pairs or other Views

 

PAM For PowerCenter DVO 9.6.0

Informatica PowerCenter Data Validation Option - 9.6.0 - Release Notes - (English)

This is a feature release of DVO with new capabilities focused on Data Connectivity, Enhanced Test Generation and Improved Usability.

 

New Features and Enhancements in DVO 9.5.2 includes:

 

  • Connectivity
    • XML data support
  • Enhanced Test Generation
    • Drag/drop creation of Value Tests
    • Import Table Pair/Single Table tests from a spreadsheet
    • Export Table Pair/Single Table tests to a spreadsheet
    • Table Pair generation via Compare Tables when table names do not match
    • Table Pair editor to address issues during auto-generation of Table Pairs
  • Usability
    • Full expression editor wherever expressions are accepted
    • SQL View UI enhancements
    • Alias individual columns in a Join View
    • View detailed metadata for imported sources/targets
    • Additional metadata in Detailed Test Results report

 

Informatica PowerCenter Data Validation Option - 9.5.2 - Release Notes - (English)

This is a feature release of DVO with new capabilities focused on performance, metadata and usability. New Features and Enhancements in DVO 9.5.1 include:

 

Performance

 

  • Data Sampling
  • Caching Support

 

Metadata

 

  • Metadata import dialog
  • Metadata refresh improvements
  • Skip invalid objects during export

 

Usability

 

  • Access Session Log file from DVO GUI
  • Support for File Lists
  • SQL Views can be used in Join Views
  • New Bad Records Tab in Test results pane

 

 

Informatica PowerCenter Data Validation Option - 9.5.1 - Release Notes - (English)

Informatica PowerCenter Integration Pack for dbMotion 1.0 has been released to shipping and is available immediately.

 

 

 

Informatica PowerCenter Integration Pack for dbMotion 1.0:

 

  • Delivers ETL (extract, transform, and load) mappings and database schema to enable data transfer from dbMotion Clinical Analytical Gateway (CAG) temporary storage into a persistent data repository;

 

  • While CAG holds only subsets of data, Informatica PowerCenter Integration Pack data repository stores a complete copy of  the production dbMotion database;

 

  • Provides rapid time-to-value through out-of-the-box functionality.

 

 

The Release Notes can be downloaded here

 

The Solution Guide can be downloaded here

 

 

Regards,

 

MySupport Team

DVO 9.5 has been released to shipping and is available immediately

 

This is a significant feature release of DVO with new capabilities aimed at larger deployments and customers with complex testing needs, particularly in production environments.

 

New Features and Enhancements in DVO 9.5

Reporting           

  • New Jasper-based reports and dashboards        
  • Single Sign On (SSO) for Web-based Reports and Dashboards.   
  • Metadata Manager Table Report             

Testing Enhancements 

  • Auto-generate Tests based on Column Position               
  • Parameterization of WHERE clauses
  • Write out all error rows encountered in Testing/Reconciliation  

Additional Enhancements           

  • Copy individual objects via the GUI         
  • Validate PowerCenter expressions in the DVO GUI         
  • Join Expressions in Join View     
  • Authentication for Domain LDAP users 
  • New Licensing Mechanism      

 

 

The Release notes for DVO 9.5 is available here

The User Guide for DVO 9.5 can be downloaded here    

 

 

Regards,

MySupport Portal Team

DVO 9.1.4 includes the followings:

 

  • Updated UI navigation
  • New Connectivity – Salesforce.com, SAS, and Netezza
  • New Connectivity - SAP (transparent tables), DB2 z/OS PowerExchange support
  • Join View – GUI to create heterogeneous joins and use them in tests
  • Support for Percentage thresholds in tests
  • Authenticate users against PowerCenter domain
  • Compare Folders dialog enhancement

 

PowerCenter Data Validation Option 9.1.4.0 Release Notes

The highlights of this release are:

 

  • Significant performance improvements when importing or refreshing PowerCenter metadata in Data Validation Option (DVO). In some internal tests, the performance was upto 10x times more.
  • Naming conventions consistent with PowerCenter. DVO no longer has case sensitivity when importing PowerCenter repository connections.
  • PAM has been improved with PWX ODBC certification with the following:
    • Db2 z/OS
    • DB2 AS/400
    • MF flat files
    • IMS
    • Adabas
  • Added ability to send confirmation and failure email after DVO mapping runs.
  • Improved auto-generation of value tests

 

Informatica PowerCenter Data Validation Option Version 9.1.2.0 Release Notes

The PowerCenter 8.6.1 HotFix 14 is strongly recommended for all customers as it contains important fixes. This is the final HotFix for PowerCenter 8.6.1.

 

Note

For Windows Itanium 64-bit, PowerCenter 8.6.1 HotFix 13 is the final HotFix.

 

 

PowerCenter Version 8.6.1 HotFix 14 Release Notes

This is a feature and bugfix release that supports all versions of PowerCenter from 8.5, 8.6.x onward, up to and including 9.01, 9.1, 9.1H1 (with the exception of 9.0).

 

Highlights of this release:

 

  • Folders - You can organize single tables and table pairs by placing them in folders
  • Error reporting - If a test fails to run, Data Validation Option displays the test run error on the Tests tab.
  • Single Tables tab - The details area contains separate tabs for table pairs and single tables.
  • DVOCmd.exe contains new commands that allow you to create users and refresh repositories.
  • Reports for tests in a folder - You can run reports for all tests in a folder. Reports display the folder name, error messages, join expressions, and conditions, if applicable.
  • When you refresh a repository, you can refresh the entire repository, the connection objects, the folders, or the sources and targets.
  • Expressions in join conditions - When you join two tables in a table pair, you can enter a PowerCenter expression as a field in the join condition. Enter an expression to join tables with key fields that are not identical.
  • Pushing sorting logic to the database - To increase the performance of table pair and single table tests, you can push the sorting logic for joins to the source database. Pushing sorting logic to the database causes the database to sort records before it loads them to PowerCenter which minimizes disk input and output.
  • Large table processing - When you include a large table in a table pair, you can optimize the way Data Validation Option joins table data. You can specify which table Data Validation Option uses for the master or detail table. You can also use sorted output for the join.
  • Filter conditions - You can apply a filter condition to table pair and single table tests. If you apply a filter condition to a table pair test, Data Validation Option applies the filter condition after it joins the tables in the table pair.

 

Informatica PowerCenter Data Validation Option 9.1.0 Release Notes

PowerChannel 9.1 is built and certified with Informatica 9.1.

 

PowerChannel 9.1 Release Notes

HotFix releases are strongly recommended for all customers.

 

PowerCenter 8.6.1 HotFix 13 Release Notes

Following are the highlights of the releases:

 

 

Dual load

The Informatica dual load solution for Teradata Dual active systems helps organizations access, integrate, and load freshest, business-critical data to construct and maintain multiple Teradata data warehouses for business continuity and disaster recovery. The dual load solution leverages the Informatica Platform, extracts and transforms the data once and simultaneously loads it into Multiple Teradata Systems (Dual Active or Active-Passive) for consistency, recovery and restart-ability.

With the Informatica dual load solution, organizations can minimize the costs,time,and risks associated with availability and protection of information in the business intelligence and data warehousing projects end-to-end. It helps IT teams fortify the Tier 1 infrastructure and meet recovery time and recovery point objectives providing the business with minute-by-minute decision‐making abilities, cross‐business unit visibility, and transparency for regulatory compliance.

 

TPT 8.6.1.0.3

  • Integration with "PowerCenter Dual Load Option for Teradata 8.6.1"
  • Bug fixes

Release Notes

PowerCenter Dual Load Option for Teradata 8.6.1

PowerExchange for Teradata PT API 8.6.1.0.3

Filter Blog

By date: By tag: