Answer Posted / satya
In addition to Kapil's answer, You can have "push down"
optimization at source database or target database or Full
(Source and target). But before you enable this option you
keep the following things in mind
1. When you are processing long transaction at database
level , The objects will be lock and data base objects are
not available for other operations for long time.
2. It will inturn hampers the datbase concurrency and
increases the chance of "Dead locks" on database
Thanks : Satya
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
How to improve the performance of a session using sorter transformation?
How can a transformation be made reusable?
Clarify the aggregator change?
How many ways a relational source definition can be updated and what are they?
Performance tuning( what you did in performance tuning)
What are the differences between joiner transformation and source qualifier transformation?
What are the tuning techniques you applied during your last project
What is pmcmd command?
Explain lookup transformation in informatica
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is the scenario which compels informatica server to reject files?
What is dynamic cache?
How to generate or load values in to the target table based on a column value using informatica etl tool.
Explain the pipeline partition with real time example?
Explain about cumulative Sum or moving sum?
