Tuesday, 13 October 2015

Difference between informatica 8.6 and 9

Difference between informatica 8.6 and 9
In informatica 8.6 unconnected lookup transformation returns only one port and in informatica 9 it returns multiple matched ports. 
The major difference is lookup transformation which is active (returns all the matched rows) in informatica 9.0. 

  1. Now Lookup can be configured as an active transformation - it can return multiple rows on successful match.
  2. Now you can write SQL override on un-cached lookup also. Previously you could do it only on cached lookup.
  3. You can control the size of your session log. In a real-time environment you can control the session log file size or time.
  4. Database deadlock resilience feature - this will ensure that your session does not immediately fail if it encounters any database deadlock (Time Base Commit Out), it will now retry the operation again. You can configure number of retry attempts.

2 comments:

  1. Did you know that you can generate money by locking premium pages of your blog / website?
    Simply join AdscendMedia and run their content locking plug-in.

    ReplyDelete
  2. Thank you so much for focusing the best on Informatica and looking forward to help out even more.

    Informatica Read JSON

    ReplyDelete

Big Data FQA

1) What is a Big Data Architecture? Generally speaking, a Big Data Architecture is one which involves the storing and processing of data...