what is the hint?
how to use it to reduce the query processing in program?
Answers were Sorted based on User's Feedback
Answer / sujatha
Hi,
Hints are used to improve the query performance. Please go
through the below link ...u will get all the info
required...
http://www.adp-gmbh.ch/ora/sql/hints/index.html
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / usha
Hints is nothing but clues.
By using hints we can improve the query performence.
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / 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 |
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
how to run 2 workflows sequentially. plz respond what is the process?
If there are more than one sessions running parallel in a worklet, which will be the last session ?
how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!
tell me the push down optimization
Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?
What does command task mean?
if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs
Can you please mail me a copy of Informatica Certification Exam dumps to sriveniv@hotmail.com
What are the prerequisite tasks to achieve the session partition?
whether Sequence generater T/r uses Caches? then what type of Cache it is
Why the workflow is failed after running two hours in informatica?