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
- 18126 Views
- Cap Gemini, IBM, I also Faced
- E-Mail Answers
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
How to start a workflow using pmcmd command?
What all join we can perform in LOOKUP transformation?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
where to store informatica rejected data?
what is unit testing?tell me proceedure
What is complex mapping?
what is Active lock explain
Explain the difference between mapping parameter and mapping variable?
Scheduling properties,whats the default (sequential)
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
How you prepared reports for OLAP?
Can u generate reports in Informatica?
Different sorts of metadata that stores in the storage facility?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
