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 create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
As union transformation gives UNION ALL output, how you will get the UNION output?
What is meant by lookup transformation?
Define filter transformation?
What are the main features of Oracle 8i with context to datawarehouse?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What is Data Caches size?
What is the difference between a repository server and a powerhouse?
Why filter transformation is an active one?
What is transformation?
What are the types of lookup transformation?
What is domain in terms of informatica?
Why is sorter an active transformation?
How can repository reports be accessed without sql or other transformations?
What is mapplet in informatica?
