What is the difference between Oracle performance and
Informatica Percfomance? Which performance is better?
Answer Posted / 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 |
Post New Answer View All Answers
Define sessions in informatica etl?
Mention a few design and development best practices for informatica?
Slowly changing dimensions, types and where will you use them
Explain the scenario which compels informatica server to reject files?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is joiner transformation?
What are the different transaction levels available in transaction control transformation?
What are roles and groups and benefits of using them?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What is a repository manager?
What is an unconnected transformation?
Whats there in global repository
Explain your project of banking domian.
generate date / time dimension in informatica
How can we use mapping variables in informatica? Where do we use them?