INFORMATICA VERSION DIFFERENCES (VERSION 7 ON WARDS TILL 9.7)

Informatica versions
====================
Informatica--->4.X-->2001
Informatica--->5.X-->2002
Informatica--->6.X-->2002-2003
Informatica--->7.X-->2004-2006
Informatica--->8.X-->2006-2009
Informatica--->9.0-->Dec 2009
Informatica--->9.1-->Mar 2011
Informatica--->9.5-->June 2012
Informatica Fast Clone--->9.6.0-->Jan 2014
Informatica Fast Clone --->9.7.0-->Dec 2014
Automatic Mapping Creation components:

1. Informatica architect for visio (an automated tool) supports on 9.1 and later version
2. GENIFA which is also a automated mapping and workflow tool

 =======================================================

Informatica 7.1 (new and enhancement components)

========================================= =============

Data Profiling

Licensing

PowerCenter Server

PowerCenter Metadata Reporter

Repository Server

Repository

Transformations

Usability

Version Control

Web services provider

Workflow Monitor

XML Support

SuSE Linux Support

Oracle OS Auth
Flat File Lookup

 =======================================================

Informatica 8.1 (new and enhancement components)

========================================= ==============

Command Line Programs

Data Analyzer (PowerAnalyzer)

Data Profiling

Domains

Integration Service (PowerCenter Server)

Mappings

Metadata Manager (SuperGlue)

Repository and Repository Service

Transformations and Caches

Usability

Web Services Provider

Workflow Monitor

XML

 =======================================================

Informatica 9.1 (new and enhancement components)

========================================= ==============

Informatica Administrator

Cache Update in Lookup Transformation

Database deadlock resilience

Multiple rows return

Limit the Session Log

Auto-commit

Passive transformation

Connection management

Monitoring

Deployment

Model Repository Service

Data Integration Service

XML Parser

Enforcement of licensing restrictions

 =======================================================

Informatica 9.5 (new and enhancement components)

========================================= ==============

Increase Agility in Delivering Critical Data and Reports to the Business .

Harness the Power of Big Data

Connect with Social Media Data

Enable true business-IT collaboration

Simplify Web services development

Boost productivity with metadata management

Test changes and upgrades up to 10x faster and increase test coverage with the Informatica Data Validation Option .

Validate Your Production Data with the Informatica Data Validation Option .

Proactively Identify Data Integration Risks

Minimize risk through data governance

Improve mainframe access and performance

Harden your real-time operations .

Bullet-proof your security

Support mission critical 24x7 operations

=======================================================

Informatica 9.6 (new and enhancement components)

========================================= ==============

Secure Sockets Layer (SSL) Connections to Oracle Sources and Targets

                Fast Clone 9.6.0 can now connect to Oracle sources and targets by using the TCP/IP protocol with the SSL 

Enhanced Support for Generating Target Tables

The Fast Clone Console 9.5.0 could generate target tables based on source table schema only for Oracle and MySQL targets. Effective in Fast Clone 9.6.0, the Fast Clone Console  can generate target tables for all of supported targets.For the generated target tables, the Fast Clone Console preserves only primary key constraints that you define on the source.Note: For Oracle and MySQL targets, you can configure the Data Replication Console to preserve default values, foreign key constraints, check constraints, unique constraints, indexes, and triggers that you define on the source.

Data Streamer for Netezza Targets

Fast Clone 9.6.0 provides the Data Streamer add-on component for Netezza targets that you can use for high-performance data load to Netezza targets. Data Streamer loads data to the target tables in parallel. For each table that you unload, Data Streamer creates a named pipe that represents a Netezza external table. Data Streamer writes unloaded data to the named pipes and the Netezza ODBC driver reads data from these pipes to load data to the target.

 New License Key Format

Fast Clone 9.6.0 uses a new license key format. Fast Clone reads a license key from the Fast Clone.key file that must be located in the top-level Fast Clone installation directory. The license key can now control the availability of the following Fast Clone features:

·         Fast Clone Server

·         Data Streamer

·         Support for Hadoop and Hive targets

The trial license now limits the number of records that the Fast Clone executable can unload from a source Database.

Important: To calculate the total number of unloaded rows, Fast Clone always uses the maximum number of rows that the trial license permits to unload from a given table. For example, the trial version of Fast Clone can unload a maximum of 10 tables that do not use WHERE clauses per unload job. For each of these tables, Fast Clone unloads a maximum of 10000 rows.

Integration with Informatica Data Replication for Initial Synchronization of Source and Target Databases

In addition to Data Replication XML configuration files, Fast Clone can now use a configuration SQ Lite database to perform an initial load of Data Replication targets.

Improved Patterns for Naming Output Files

The Fast Clone Console now has the following parameters to specify patterns for output file names:

•Naming pattern for data files specifies the naming pattern that Fast Clone uses to create the base name of the output data files

.•Naming pattern for control files specifies the naming pattern that Fast Clone uses to generate names for control files, log files, and SQL scripts.

In the naming pattern, you can now include the following new variables:

•%&source_schema&% represents a source schema name.

•%&target_schema&% represents a target schema name.

       Support for Hive Data Warehouse Targets

Fast Clone 9.6.0 can now unload source data to Hive targets.

         Fast Clone now supports Internet Protocol version 6 (IPv6).

BEHAVIOR CHANGES:

Informatica Fast Clone 9.6.0 introduces the following change in the behavior of the Fast Clone executable.

Data Inconsistency Warnings

Fast Clone performs a checkpoint before starting a data unload job to ensure that the database flushes all data from memory to disk. In previous versions, if a user changes data in the source database when the unload job is still running, Fast Clone might unload inconsistent data.

Effective in Fast Clone 9.6.0, Fast Clone determines the Start SCN value that corresponds to point immediately after the checkpoint when Fast Clone started unloading data. During unload processing the Fast Clone compares the start SCN value with the SCN value of the last change in each unloaded data block. If the block SCN value is greater than the Start SCN value, Fast Clone logs a warning and continues unload processing.

Fast Clone 9.6.0 introduces a new runtime parameter validate_block_scn that determines whether to write a warning message to a log file when a block SCN value is greater than the Start SCN value.

Parameter Changes

 Informatica Fast Clone 9.6.0 introduces changes to the following parameters:

            Parameters that you configure in the Fast Clone configuration file.

            Start parameters that you enter with the Fast Clone executable at a command line.