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
Explain the shared cache and re-cache?
What are the databases that informatica can connect to windows?
Where do we use mapping variables in informatica?
How can repository reports be accessed without sql or other transformations?
How does a sorter cache works?
What is the different lookup cache(s)?
What are the types of schemas we have in data warehouse and what are the difference between them?
What is an expression transformation in informatica?
What are the different types of transformation available in informatica.
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.
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
How will the document be delivered to me?
Under what condition selecting sorted input in aggregator may fail the session?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What is joiner transformation in informatica?
