what is the difference between Informatica7.1 & informatica
8.1
Answers were Sorted based on User's Feedback
Answer / chinna
caches or automatic u dont need to allocate at
transformation level,
push down optimization techniques,some new java
transformations,changes in parameter file
and intigration services rather than powercentre server
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / ashok
1)powercenter connect for SAP NetWeaver BW Option
2)SQL Transformation is added
3)Service Oriented Architecture
4)Grid concept is additional feature
5) Random file name can genaratation in target
6) Command line programms: Infacmd and infasetup new
commands were added.
7) Java Transformation is added feature
8)concurrent cache creation and faster index building are
additional feature in lookup transformation
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / amarnath
1. Java transformation
2. CDC mapping template
3.pushdown optisation
4. sql transformation
5. C++ doing can be done
6. Integration service introduced.
7. SOA
8.while loading into flat file we can append the rows
9. web based administration console
10. now we can work with unstructured data like pdf,ms word
etc.
11.GUI look and feel change
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / chowdary
The main differences between Informatica7.1 & 8.1 is
1.Java transformation support
2.Extended expression library&user defined functions
3.Mapping templates
4.Global and web based administration console
| Is This Answer Correct ? | 1 Yes | 0 No |
How to find from a source which has 10,000 records, find the average between 500th to 600th record?
i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.
what is bridge tables in informatica
What are different types of transformations available in informatica?
How do you load unique records into one target table and duplicate records into a different target table?
My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000
What is Index Caches size?
What if the source is a flat-file?
what is metadata?
What is the use of transformation?
Which files are created during the session rums by informatics server?
Which kind of index is preferred in DWH?