Interested to Buy Any Domain ? << Click Here >> for more details...
how to through logic of informatica using the push down
optimization into oracle.
- 2 Answers
- 7752 Views
- Hexaware, I also Faced
- E-Mail Answers
Answer Posted / venubyna1
Asession configure for push down optimization to Increase
the session performance.
The I.S Analyze the mapping and T/r logic and determine T/r
logic it ll send to the source or Tager data base
I.S is convert the T/r logic into SQL then send to the data
base server
there r 3 types
1. Source side push down
2.Target side push down
3.fullside push down
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Is it possible to define a single node as a Gateway node as well as worker node?
Under which circumstances, informatica server creates reject files?
What is workflow monitor?
What does “tail –f” command do and what is its use as an Informatica admin.
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
How many dimensions are there in informatica?
How to differentiate between the active and passive transformations?
tell me about your project functionality
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What differs when we choose the sorted input for aggregator transformation?
whats the logic to load the lower level of granularity of data to fact table.
What is Index Caches size?
What will be the approach?
What is the surrogate key?
what is the Default Source Option For Update Strategy Transformation?
