As I worked as Informatica developer so the changes in different versions of Informatica which I came across while development will explain those only, to be frank I never worked in Informatica Admiration so that I know them only theoretically.
Informatica 9 empowers line-of-business managers and business analysts to identify bad data and fix it faster. Architecture wise there are no differences between Informatica 8 and 9 but there are some new features added in power center 9.
Cache Update In Lookup Transformation.
We can update the lookup cache based on the results of an expression. When an expression is true, you can add to or update the lookup cache. Also we can update the dynamic lookup cache with the results of an expression.
Database Deadlock Resilience
In previous releases, when the Integration Service encountered a database deadlock during a lookup, the session failed. Effective in 9.0, the session will not fail. When a deadlock occurs, the Integration Service attempts to run the last statement in a lookup. Also we can configure the number of retry attempts and time period between attempts.
Multiple Rows Return Property In Lookup.
Lookups can now be configured as an Active transformation to return Multiple Rows. We can configure the Lookup transformation to return all rows that match a lookup condition. A Lookup transformation is an active transformation when it can return more than one row for any given input row.
Limit The Session Log.
We can limit the size of session log for real-time sessions. In that we can limit the size by time or by file size. We can also limit the number of log files for a session.
We can enable auto-commit for each database connection. Each SQL statement in a query defines a transaction. A commit occurs when the SQL statement completes or the next statement is executed, whichever comes first.
Passive SQL Transformation.
We can configure the SQL transformation to run in passive mode instead of active mode. When the SQL transformation runs in passive mode, the SQL transformation returns one output row for each input row.
Database connections are centralized in the domain. We can create and view database connections in Informatica Administrator, Informatica Developer, or Informatica Analyst. Create, view, edit, and grant permissions on database connections in Informatica Administrator.
We can monitor profile jobs, scorecard jobs, preview jobs, mapping jobs, and SQL Data Services for each Data Integration Service. View the status of each monitored object on the Monitoring tab of Informatica Administrator.
We can deploy, enable, and configure deployment units in the Informatica Administrator. Deploy Deployment units to one or more Data Integration Services. Create deployment units in Informatica Developer.
Thanks & Regards,