What are the new features of Informatica 9.x in developer level:
- Now Lookup can be configured as an active transformation - it can return multiple rows on successful match
- Now you can write SQL override on un-cached lookup also. Previously you could do it only on cached lookup
- You can control the size of your 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 your session does not immediately fail if it encounters any database deadlock, it will now retry the operation again. You can configure number of retry attempts.
