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
- 18433 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
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
Describe the impact of several join conditions and join order in a joiner transformation?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What are the different versions of informatica?
What is sequence generator transformation in informatica?
Tell me about Propagate functions in informatica
What is meant by lookup transformation?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What is sorter transformation?
What is substr in informatica?
Differentiate between a database and data warehouse?
What is data caches/ index caches?
server hot-ws270 is connect to Repository B. What does it mean?
Mention few advantages of router transformation over filter transformation.
