what is the hint?
how to use it to reduce the query processing in program?
Answer Posted / gazulas
by using hints we can direct the optimizer to follow what was specified in the hints. ex: we can direct the optimizer to do a index unique scan instead of full table scan....
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why filter transformation is an active one?
What do you mean incremental aggregation?
What are the differences between oltp and olap?
Where are the source flat files kept before running the session?
How can you differentiate between powercenter and power map?
How does the aggregator transformation handle null values?
Is it possible to revert a global repository to local one and why?
What is rank transformation in informatica
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What happens when a session fails and you click on recover?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
How to load the data from people soft hrm to people soft erm using informatica?
Enlist few areas or real-time situations where informatica is required.
design of staging area?
What are the tasks that can be performed using sq?