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
Why do we need informatica?
What is the use of an aggregator cache file?
Define the various join types of joiner transformation?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What is repository manager?
Explain pushdown optimization and types in informatica
How can a transformation be made reusable?
Explain what is informatica metadata and where is it stored?
Define sessions in informatica etl?
Where do we use mapping variables in informatica?
How to do the error handling of if ur source is flatfiles?
Explain the etl program with few examples.
What is an aggregator transformation?
What is the difference between STOP and ABORT options in Workflow Monitor?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?