What is the difference between Oracle performance and
Informatica Percfomance? Which performance is better?

Answers were Sorted based on User's Feedback



What is the difference between Oracle performance and Informatica Percfomance? Which performance i..

Answer / radha

oracle performence deals with the source &targets.
informatica performanc deals with the tranformations.
for effficient result both are impotent...

Is This Answer Correct ?    17 Yes 3 No

What is the difference between Oracle performance and Informatica Percfomance? Which performance i..

Answer / 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

What is the difference between Oracle performance and Informatica Percfomance? Which performance i..

Answer / ankit kansal

Both Informatica and Oracle tuning plays important role while you are considering overall architectural tuning.
Oracle Tuning Involves:
1) Indexes
2) Constraints
3) Triggers
4) Dimensional Modelling Involved
5) DB Load at that particular Time
Informatica Tuning Involves
1) How mappings are created
2) Cache Availability
3) Reader Writer and Transformation Threads
4) Partitioning (Major)

and many more.... each plays a significant role while you are tuning your complete system

Is This Answer Correct ?    1 Yes 0 No

What is the difference between Oracle performance and Informatica Percfomance? Which performance i..

Answer / jayesh

Orcale performance is better.Because informatica is nothing
but a metadata.Informatica is there only to play with data.
Ya but at the end of the day what matters is how you design
the logic.

Is This Answer Correct ?    1 Yes 5 No

Post New Answer

More Informatica Interview Questions

in oracle write query yourname+1 from dual

5 Answers  


Why we use ENABLE HIGH PRECISION in session properties?

2 Answers   Cognizant,


What are the components of workflow manager?

0 Answers  


What are the modules in Power Center

0 Answers  


In which circumstances that informatica server creates Reject files?

2 Answers  






How do you change a non-reusable transformation to reusable transformation?

0 Answers  


How do you load first and last records into target table?

0 Answers  


i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .

6 Answers   Emphasis,


What is informatica worklet?

0 Answers  


What is exclusive and normal mode for repository services?

0 Answers  


what is the diff b/w union and joiner and lookup?

4 Answers  


what is update strategy transformation ?

7 Answers   TCS,


Categories