Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Oracle performance and
Informatica Percfomance? Which performance is better?
- 4 Answers
- 18248 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 |
can we load the data with out a primary key of a table? what is target plan?
Differentiate between a database and data warehouse?
performance tuning of Informatica
Are there any types of Dynamic Caches in informatica
When do you use sql override in a lookup transformation?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?
what is the need of session partitioning... how it is useful in real time
What are mapplets? How is it different from a Reusable Transformation?
What do you understand by a term domain?
update strategy transformation in informatica
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
Teradata 
