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 are multi-group transformations?
What are the different ways to implement parallel processing in informatica?
To import the flat file definition into the designer where should the flat file be placed?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What is a sorter transformation?
What is Session and Batches?
Explain incremental aggregation in informatica
Is there any target staging area in informatica not staging area
Sequence generator, when you move from develoment to production how will you reset
In informatics server which files are created during the session rums?
is it possible to index the data in cache of lkp transformation ?
What is the Rank index port in Rank transformation?
How to extract sap data using informatica?
Scheduling properties,whats the default (sequential)
What is mapplet in informatica?
