what is the hint?
how to use it to reduce the query processing in program?
Answer Posted / 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 |
Post New Answer View All Answers
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
What is the Process to creating lookup transformation in informatica
Mention few power centre client applications with their basic purpose?
What are the different transaction levels available in transaction control transformation?
Why update strategy and union transformations are active?
Explain the features of connected and unconnected lookup.
What is Session and Batches?
How to configure mapping in informatica?
What are the new features of informatica 9.x at the developer level?
What is the difference between STOP and ABORT options in Workflow Monitor?
What is different between the data warehouse and data mart?
Explain the different dimensions.
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Briefly describe lookup transformation?
How might you approve all mappings in the archive all the while?