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 |
Is it possible to create multiple domains on a single Informatica server?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
what is size of u r database?
By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?
A Main workflow "wkf_Main" has multiple sessions (S1, S2...., can I make changes and promte one session (S5) at any time or have to promote whole Workflow "wkf_Main" every time?
my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer
What is enterprise data warehousing?
what is meant by lookup caches?
2 Answers Cap Gemini, Informatica,
What are the options in the target session of update strategy transsformatioin?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What is the use of code page?
Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static