| |
- The architecture of Power Center 8 has changed a lot; PC8 is service oriented for modularity, scalability and flexibility.
- The Repository Service and Integration Service (as replacement for Rep Server and Informatica Server) can be run on different computers in a network (so called nodes), even redundantly.
- Management is centralized, that means services can be started and stopped on nodes via a central web interface.
4) Client Tools access the repository via that centralized machine, resources are distributed dynamically.
- Running all services on one machine is still possible, of course.
- It has a support for unstructured data which includes spreadsheets, email, Microsoft Word files, presentations and .PDF documents. It provides high availability, seamless fail over, eliminating single points of failure.
- It has added performance improvements (To bump up systems performance, Informatica has added "push down optimization" which moves data transformation processing to the native relational database I/O engine whenever its is most appropriate.)
- Informatica has now added more tightly integrated data profiling, cleansing, and matching capabilities.
- Informatica has added a new web based administrative console.
- Ability to write a Custom Transformation in C++ or Java.
- Midstream SQL transformation has been added in 8.1.1, not in 8.1.
- Dynamic configuration of caches and partitioning
- Java transformation is introduced
- User defined functions
- Power Center 8 release has "Append to Target file.
|
Informatica Interview Question and Answers