What is the difference between Oracle performance and
Informatica Percfomance? Which performance is better?
Answer Posted / 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 |
Post New Answer View All Answers
can anyone suggest best free Talend data integration training online
What is the use of source qualifier?
have u done any performance tuning? how u ll do?
What is complex mapping?
How you know when to use a static cache and dynamic cache in lookup transformation?
Where do we use mapping variables in informatica?
What is a router transformation?
Mention few advantages of router transformation over filter transformation.
What are the different lookup cache(s)?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Differentiate between joiner and lookup transformation?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Describe expression transformation?
What is a filter transformation and why it is an active one?
What is session task and command task?