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
- 17865 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 sorter transformation?
What is expression transformation?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
How can a transformation be made reusable?
Which files are created during the session rums by informatics server?
what is informatica metadata?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is workflow? What are the components of the workflow manager?
What are the prerequisite tasks to achieve the session partition?
waht type of interface is used for testing the data in informatica
What are active transformations.
tell me about your project functionality
What are the mapping parameters and mapping variables?
