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
- 18430 Views
- Cap Gemini, IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / radha
oracle performence deals with the source &targets.
informatica performanc deals with the tranformations.
for effficient result both are impotent...
| Is This Answer Correct ? | 17 Yes | 3 No |
Answer / afsar
Generally we check for busy percentage in session log if
its source busy % or Tgt% is more then we try to do
database tunning,if its transformance % is more then go for
Informatica part.But form my side I would rather suggest
for both kind of performance
| Is This Answer Correct ? | 5 Yes | 3 No |
Answer / 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 |
Answer / jayesh
Orcale performance is better.Because informatica is nothing
but a metadata.Informatica is there only to play with data.
Ya but at the end of the day what matters is how you design
the logic.
| Is This Answer Correct ? | 1 Yes | 5 No |
What are the hard ware required for a normal sized data warehouse? and What are the software required for a normal kind of data warehouse?
What is the functionality of update strategy?
In session log thier should not be a single error how will u do
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
Explain load alternative records / rows into multiple targets - informatica
Could any one to tell How to use the Oracle Analytic functions in Informatica?
how to remove staging area
how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!
What is polling?
i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?
what is normalization? explain 1st NF, 2nd NF, 3rd NF
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
Teradata 
