What is the difference between Oracle performance and
Informatica Percfomance? Which performance is better?
- 4 Answers
- 17365 Views
- Cap Gemini, IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
How to convert multiple rows to single row (multiple columns) in informatica
Is stop and abort are same in informatica?
I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.
how can u load the data in time dimension?
What is decode in informatica?
How do you handle two sessions in Informatica
Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What are the new features of informatica 9.x developer?
hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks... Send me----: raghukrams@yahoo.com
How to improve the performance of a session using sorter transformation?
what is the need of session partitioning... how it is useful in real time
Teradata 
