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
- 18226 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
Explain pushdown optimization and types in informatica
Scheduling properties,whats the default (sequential)
How to partition the Session?
what are the deliverables?in your project?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What is a passive transformation?
explain one complex mapping with logic? sales project?
What is joiner transformation in informatica?
How to go to the older version for a mapping?
What is the need of etl tools?
How do you load only null records into target? Explain through mapping flow.
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
Difference between Target-based loading and constraint-based loading?
How can you validate all mappings in the repository simultaneously?
Briefly describe lookup transformation?
