INTERVIEW QUESTIONS DATA WAREHOUSING INFORMATICA DETAILS

Question: What is the difference between Informatica 7.0 and 8.0 ?

Answer: the basic diff b/w inbetween informatica8.0and informatica7.0 is that in 8.0series informatica corp has introduces powerexchnage
concept

the basic diff b/w inbetween informatica8.0and informatica7.0 is that in 8.0series informatica corp has introduces powerexchnage
concept
Source: CoolInterview.com

There is Architecture difference also the transformations like java,HTTP are new in 8.0
in email task we can have pdf facility Source: CoolInterview.com

in this 8 version advanced 10 transformations r there and java transformation is one main Source: CoolInterview.com

Features of Informatica 8
The architecture of Power Center 8 has changed a lot;
1. PC8 is service-oriented for modularity, scalability and flexibility.
2. 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.
3. 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.
5. Running all services on one machine is still possible, of course.
6. 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.
7. 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.)
8. Informatica has now added more tightly integrated data profiling, cleansing, and matching capabilities.
9. Informatica has added a new web based administrative console.
10.Ability to write a Custom Transformation in C++ or Java.
11.Midstream SQL transformation has been added in 8.1.1, not in 8.1.
12.Dynamic configuration of caches and partitioning
13.Java transformation is introduced.
14.User defined functions
15.PowerCenter 8 release has "Append to Target file" feature.
Source: CoolInterview.com

I know little bit of Informatica 7X and want to learn informatica 8 . What should I do , where to start from . Source: CoolInterview.com

easyly understanding and database will be small changes Source: CoolInterview.com

The major difference is Informatica 8x mainly works on SOA where as the Informatica 7x works on Client and Server Architecture concept. Source: CoolInterview.com

the main differences are time concept also and more advanced transformations are released like java and sql transformations etc Source: CoolInterview.com

7.0 is server,8.0 is service.in 7.0 it contain 5 clients in 8.0 4 clients(admin_console(spl)) Source: CoolInterview.com

sdf Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

• There should not be any Spelling Mistakes.
• There should not be any Gramatical Errors.
• Answers must not contain any bad words.
• Answers should not be the repeat of same answer, already approved.
• Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question