top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What is the difference between informatica 7.1 and 8.6 versions?

+2 votes
1,022 views
What is the difference between informatica 7.1 and 8.6 versions?
posted Jan 18, 2016 by Amit Sharma

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

1. Target from Transformation: In Informatica 8X we can create target from Transformation by dragging transformation in Target designer

2. Pushdown optimization: Uses increased performance by pushing Transformation logic to the database by analyzing the transformations and Issuing SQL statements to sources and targets. Only processes any Transformation logic that it cannot push to the database.

3. New function in expression editor: New function have been introduced in Informatica 8X like reg_extract and reg_match

4. Repository query available in both versioned and non versioned Repositories previously it was available only for versioned repository.

5. UDF (User defined function) similar to macro in excel

**6. FTP:** We can have partitioned FTP targets and Indirect FTP File source (with file list).

7. Propagating Port Descriptions: In Informatica 8 we can edit a port description and propagate the description to other transformations in the mapping.

8. Environment SQL Enhancements: Environment SQL can still be used to Execute an SQL statement at start of connection to the database. We can Use SQL commands that depend upon a transaction being opened during The entire read or write process. For example, the following SQL command Modifies how the session handles characters: Alter session set

NLS_DATE_FORMAT='DD/MM/YYYY';".

9. Concurrently write to multiple files in a session with partitioned targets.

10. Flat File Enhancements:

  • Reduced conversion of data types
  • Delimited file performance has improved
  • Flat file now can have integer and double data types

  • Data can be appended to existing flat files
    Informatica power center 8 is having the following features which makes it more powerful, easy to use and manage when compared to previous versions.

  • Supports Service oriented architecture

  • Access to structured, unstructured and semi structured data
  • Support for grid computing
  • High availability
  • Pushdown optimization
  • Dynamic partitioning
  • Metadata exchange enhancements
  • Team based Development
  • Global Web-based Admin console
  • New transformations
  • 23 New functions
  • User defined functions
  • Custom transformation enhancements
  • Flat file enhancements
  • New Data Federation option
  • Enterprise GRID
answer Jan 19, 2016 by Manikandan J
Similar Questions
+1 vote
Informatica powercenter installation 8.6.1 error : pmjrepn (A parameter must be a directory.)

I get this error at the moment of create domain on informatica Powercenter 8.6.1 silent install :

Informatica PowerCenter 8.6.1

Cannot create domain.

The installer could not create the domain. Correct the error below and select
Retry. You must successfully create the domain to continue the installation.
DEFINE_NODE_STDOUT:
DEFINE_NODE_STDERR:java.lang.UnsatisfiedLinkError: pmjrepn (A parameter must be a directory.)
at java.lang.ClassLoader.loadLibraryWithPath(ClassLoader.java:952)
at java.lang.ClassLoader.loadLibraryWithClassLoader(ClassLoader.java:921)
at java.lang.System.loadLibrary(System.java:452)
        at com.informatica.powercenter.sdkint.repository.ILocaleManager.<clinit>(ILocaleManager.java:38)
at java.lang.J9VMInternals.initializeImpl(Native Method)
at java.lang.J9VMInternals.initialize(J9VMInternals.java:187)
        at
com.informatica.pcsf.infacmd.InfaCmdMainLoop.mainLoop(InfaCmdMainLoop.java:100)
at com.informatica.pcsf.infacmd.InfaSetupMain.main(InfaSetupMain.java:34)
Exception in thread "main" java.lang.UnsatisfiedLinkError: pmjrepn (A parameter
must be a directory.)
at java.lang.ClassLoader.loadLibraryWithPath(ClassLoader.java:952)

Any ideas?

...