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
Parameter and variable differences
What is the sequence generator transformation in informatica?
What does refresh system mean, and what are its distinctive choice?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is Session and Batches?
How can we use mapping variables in informatica? Where do we use them?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is joiner transformation in informatica?
What is depict expression change?
difference between repository database and repository service?
How to elaborate tracing level?
What are the designer tools for creating transformations?
What is mapplet in informatica?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What is the use of code page?