what is the difference between Informatica7.1 & informatica
8.1
- 4 Answers
- 8058 Views
- I also Faced
- E-Mail Answers
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 |
write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000
How to calculate the cache size if say we are doing a performance check on a mapping and found that a particular cache needs to be changed. Is there a formula to calculate this! i know that informatica has a auto option available but how to calculate manually?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What is the difference between unicode & ascii mode data movement in informatica?
What is dimensional table? Explain the different dimensions.
What is the difference between STOP and ABORT options in Workflow Monitor?
in my source table i want to delete first and last records and load in between records into target? how can it possible?
3 Answers HCL, Thomson Reuters,
how to obtain performance data for individual transformations.
what is confirmed dimension?
What are the different types of code pages available in informatica & how to implement it in your project?
Explain load alternative records / rows into multiple targets - informatica
I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?
Teradata 
