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 |
What is parameter file?
What is A complex mapping?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
If you done any modifications for a table in back end does it reflect in informatca warehouse or maping?
How will you update the first four rows and insert next four rows in a mapping?
disable caching in a lookup transformation?
Hi can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?
How big was your fact table
What are the parts of Informatica Server?
What is the use of source qualifier?
how many types transformations supported by sortedinput?
Explain the different dimensions.