What is the difference between Oracle performance and
Informatica Percfomance? Which performance is better?
- 4 Answers
- 17409 Views
- Cap Gemini, IBM, I also Faced
- E-Mail Answers
Answer Posted / afsar
Generally we check for busy percentage in session log if
its source busy % or Tgt% is more then we try to do
database tunning,if its transformance % is more then go for
Informatica part.But form my side I would rather suggest
for both kind of performance
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
Write the unconnected lookup syntax and how to return more than one column.
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Briefly define reusable transformation?
Explain lookup transformation is active in informatica
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What are the different versions of informatica?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Difference between Data and Index Caches?
How to load data in informatica ?
What is target load order?
I have a flat file, want to reverse the contents of the flat file
Why do you use Mapping Parameter and mapping variable?
What is informatica powercenter repository?
Define Pmrep command?
Enterprise data warehouse your projects phase by phase explain?
