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
can u give example for factless fact table
Describe an informatica powercenter?
What are the tasks that can be performed using sq?
Briefly describe lookup transformation?
Briefly define a session task?
What is the difference between router and filter?
Explain the code page compatibility?
Explain the tuning lookup transformation - informatica
What is option by which we can run all the sessions in a batch simultaneously?
What is mapping debugger?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
How can you validate all mappings in the repository simultaneously?
Write the prerequisite tasks to achieve the session partition?
Different circumstance which drives informatica server to expel records?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?