What is the difference between Oracle performance and
Informatica Percfomance? Which performance is better?
- 4 Answers
- 16708 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 |
What are the different types of code pages available in informatica & how to implement it in your project?
What are the different types of transformation available in informatica.
What is workflow variable? When we use workflow variable? Can any one explain me with one example???
How can yoU create or import flat file definition in to the warehouse designer?
When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?
What is the benefit of partitioning a session?
i have two sources two flatfiles same structure one flatfile contain 100 million recs another flatfile contain 10 million recs i have to connect single target(performance oriented answer) what are the steps we have to do this scenario
What are the types of lookup caches?
10 Answers Accenture, IBM, Informatica,
what type of problem you faced insales project or insurance project
what is diff between IN and EXIT commands
what is the difference between onsite & client site?
Insert else update option in which situation we will use
Teradata 
