Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is an aggregator transformation?
how to create user defined function (udf) in informatica
What are the different options available for update strategy?
What is union transformation?
What is the difference between informatics 7x and 8x and what is latest version?
Explain the etl program with few examples.
What are the types of data warehouses?
Enlist the tasks for which source qualifier transformation is used.
Can we override a native sql query within informatica?
How we can create indexes after completing the loan process?
How to load last n records of file into target table - informatica
How to start a workflow using pmcmd command?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
How can we delete duplicate rows from flat files?
can we override a native sql query within informatica? Where do we do it? How do we do it?
