What are the new features of Informatica 9.x Developer?

From an Informatica Developer’s perspective, some of the new features in Informatica 9.x are as follows:

  1. Lookup can be configured as an active transformation—it can return multiple rows on successful match.
  2. You can write SQL override on uncached lookups also. Previously, you could do it only on cached lookups.
  3. You can control the size of the 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 the session does not immediately fail if it encounters any database deadlock; it will now retry the operation again. You can configure the number of retry attempts.