Interested to Buy Any Domain ? << Click Here >> for more details...
what is the hint?
how to use it to reduce the query processing in program?
- 3 Answers
- 7668 Views
- Cegedim, I also Faced
- E-Mail Answers
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 |
How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????
What are the new features of Power Center 5.0?
we r using aggregator with out using groupby?
7 Answers HSBC, Principal Finance,
What are mapplets?
tell me 7.x and 8.x diferrencess(but not transformations)
Explain what are the different versions of informatica?
In mapping f.f as one src and f.f as trg,f.f as src and oracle as trg which is fast? mean which is complete first process
Work flow failed when it is set to Bulk mode but it was successful when set to normal mode y??(All the connections are fine and exactly correct)?
in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna
lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?
What is fact table? Explain the different kinds of facts.
How many dimensions are there in informatica?
Teradata 
