Interested to Buy Any Domain ? << Click Here >> for more details...
how can we update without using update transformation.
wt is push down operation in informatica.
which lookup gives more tuning performance. if so why.
- 6 Answers
- 17611 Views
- CTS, Symphony, I also Faced
- E-Mail Answers
Answer Posted / ashwin
We can use update override in the target table in mapping.
Push Down Optimization is an optimizing technique in
informatica 8. Integration service pushes the transformation
logic either to the source database or to the target
database rather than executing the logic by itself.
I think dynamic lookup gives a better performance since it
allows us to tune the cache sizes(index and data).
| Is This Answer Correct ? | 2 Yes | 6 No |
Post New Answer View All Answers
What is a stored procedure transformation?
What is the difference between writing a joiner query in ANSI style and THETA style?
Describe an informatica powercenter?
What does update strategy mean, and what are the different option of it?
COM components can be used in Informatica
Parameter and variable differences
waht type of interface is used for testing the data in informatica
How is union transformation utilized?
What is sq transformation?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Informatica Checkpoints
State the differences between sql override and lookup override?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What do you understand by term role-playing dimension?
Is there any way to read the ms excel datas directly into informatica?
