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
- 18044 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
What are mapplets?
what is mean by complex business rule ?
Differentiate between joiner and lookup transformation?
Enterprise data warehouse your projects phase by phase explain?
What is Data Caches size?
Mention some types of transformation?
How do you use reject loader.
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What are the databases that informatica can connect to windows?
What are ETL Tools?
Explain pmcmd command usage in informatica
what is the -ve test case in your project.
what is the Default Source Option For Update Strategy Transformation?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is the maplet?
