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
What are batches?
is it possible to index the data in cache of lkp transformation ?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What are the features of complex mapping?
Explain the use of aggregator cache file?
Explain the different kinds of facts.
What are ETL Tools?
Explain scd type 3 through mapping.
Difference between Data and Index Caches?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
explain abt ur project architecture?
Mention few power centre client applications with their basic purpose?
What is a node in Informatica?
What is status code in informatica?
Explain how to import oracle sequence into informatica?