Hi... this was asked in acccenture interview can anyone plz tell me the answerwhat is the difference between informatica 7.1 and 8.1

  • Interview Candidate
  • 36
  • 11256

Showing Answers 1 - 36 of 36 Answers

srinivas

  • Jan 10th, 2007
 

INFORMATICA 7.1 WE CAN USING FLAT FILE LOOK TRS IN THE MAPPING AND WE DON'T CALL JAVA SCRIPTS BUT IN 8.1 JAVA SCRIPTS ARE  NEWLY INTRODUCED.

OK BYE

  Was this answer useful?  Yes

Sravan Kumar

  • Jan 11th, 2007
 

Heard that Mapping Templets are introduced in 8.1

  Was this answer useful?  Yes

Amit dhamane

  • Jan 17th, 2007
 

    Hi,
There are # of differences bet 7.X and 8.X
In 8.x we are having domain and nodes concept, Java transformation, sql transformation, Data quality is improved after the acquisition of similarity, webservices are also introduced. I think deployment option was not there in 7.1 this is also introduced in 8.1. now u can encode and decode data in Informatica 8.1. Look and feel of the transformation is also changed..they are more lighter and quicker. Data and index cache sizes are automatically set at runtime based on # of records etc...

  Was this answer useful?  Yes

pramod

  • Jan 25th, 2007
 

Hi,Other than nodes and java transformations, the one other important feautre in version 8 is the pushdown optimization. Informatica service engine dynamically runs the tranformation logic within the database itself which improves the performance a lot. I recntly loaded 10 million records in less than 20 seconds but there are many constraints with pushdown.

  Was this answer useful?  Yes

dl_mstr

  • Feb 10th, 2008
 

The architecture of Power Center 8 has changed a lot; 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) Power Center 8 release has "Append to Target file"

  Was this answer useful?  Yes

dl_mstr

  • Feb 10th, 2008
 

  1. Power Center 8 release has "Append to Target file" feature.
  2. ava transformation is introduced.
  3. User defined functions
  4. Midstream SQL transformation has been added in 8.1.1, not in 8.1.
  5. Informatica has added a new web based administrative console.
  6. Management is centralized, that means services can be started and stopped on nodes via a central web interface

  Was this answer useful?  Yes

prasad.t

  • Jul 21st, 2009
 

Hi ,The main difference between informatica 7.1 and 8.1 are as follows;
1.1At Architecture level:-
In 7.x you will get two server components i.e Repository Server And Informatica Server but in 8.x Architeture enhanced to SOA(SERVICE ORIENTED ARCHITETURE)
2.At Domain Level:
Here no concept of domain But in 8.x Concept of domain introduced which is a logical grouping of nodes,services,user with a common set of corre services say-log services,authorization services.
Users and Group information stored @repository level
3.Communication Protocol:
All clients tools and integration services communicate with repository server over tcp/ip but in 8.x All client tools communicate with metadata reopsitory via repository services
4.Server Grid
In 7.x load balancing by round robin assign workflow explicitly to pmserver but in 8.x Priority based and current load on informatica server used to load balance.
5.pushdown optimization:
no concept of pushdown optimization in 7.x but in 8.x Executing mapping t/r login directly on database
6.version Control
Version is in built in the suite and version control not available for user defined functions but in 8.x Enhanced versioned contol objects.Explicit checkout of objects possible from this version onwards.
8. new t/r added in 8.x say java t/r.


Correct me if i am wrong


  Was this answer useful?  Yes

dpotluri

  • Jan 13th, 2010
 

More to add..

1. Deployment groups
2. Data Masking and HTTP Transformations
3. Grid Support
4. Partitioning based on number of CPUs
5. INSTR, REG_REPLACE string functions
6. LDAP authentication in user management
7. SYSTIMESTAMP

  Was this answer useful?  Yes

Vegiraju

  • Aug 14th, 2011
 

Push down optimization
Target from Transformation
UDF
concurrently write files
Flat file Enhancement

  Was this answer useful?  Yes

prashant

  • Sep 3rd, 2011
 

main difference between informatica 7.x and 8.x are:-

1. Java transformation is introduced in Informatica 8.x. while was not in 7.x

2.and Power exchange tool also introduced in informatica 8.x while was not in 7.x

  Was this answer useful?  Yes

jyothi

  • Jul 24th, 2012
 

service oriented Architecture,Pushdown Optimization,sql t/r is added,java t/r is add

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions