From an Informatica Developer’s perspective, some of the new features in Informatica 9.x are as follows:
- Lookup can be configured as an active transformation—it can return multiple rows on successful match.
- You can write SQL override on uncached lookups also. Previously, you could do it only on cached lookups.
- You can control the size of the session log. In a real-time environment, you can control the session log file size or time.
- 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.