srinivas
Answered On : 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
Login to rate this answer.
Sravan Kumar
Answered On : Jan 11th, 2007
Heard that Mapping Templets are introduced in 8.1
Login to rate this answer.
Amit dhamane
Answered On : 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...
Login to rate this answer.
pramod
Answered On : 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.
Login to rate this answer.
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"
Login to rate this answer.
- Power Center 8 release has "Append to Target file" feature.
- ava transformation is introduced.
- User defined functions
- Midstream SQL transformation has been added in 8.1.1, not in 8.1.
- Informatica has added a new web based administrative console.
- Management is centralized, that means services can be started and stopped on nodes via a central web interface
Login to rate this answer.
Think Informatica 8. has browser based fetures i.e. Java enabled.
Login to rate this answer.
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
Login to rate this answer.
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
Login to rate this answer.
Vegiraju
Answered On : Aug 14th, 2011
Push down optimization
Target from Transformation
UDF
concurrently write files
Flat file Enhancement
Login to rate this answer.
prashant
Answered On : 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
Login to rate this answer.
jyothi
Answered On : Jul 24th, 2012
service oriented Architecture,Pushdown Optimization,sql t/r is added,java t/r is add
Login to rate this answer.
