Informatica Interview Question and Answers

37. What are the environments in which informatica server can run on?
  • Informatica client runs on Windows 95 / 98 / NT, Unix Solaris, Unix AIX(IBM)
  • Informatica Server runs on Windows NT / Unix
  • Minimum Hardware requirements
  • Informatica Client Hard disk 40MB, RAM 64MB
  • Informatica Server Hard Disk 60MB, RAM 64MB
Your Name Your Email-ID
Your Answer
38. Can unconnected lookup return more than 1 value?
Your Name Your Email-ID
Your Answer
39. What is the difference between informatica 7.1 and 8.1?
  • 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.
Your Name Your Email-ID
Your Answer
40. Which all databases PowerCenter Server on UNIX can connect to?
  PowerCenter Server on UNIX can connect to following databases
  • IBM DB2
  • Informix
  • Oracle
  • Sybase
  • Teradata
Your Name Your Email-ID
Your Answer

131415 Page 10 of 15