Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

what is the hint?
how to use it to reduce the query processing in program?

Question Posted / teja_dwh

Answers were Sorted based on User's Feedback



what is the hint? how to use it to reduce the query processing in program?..

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

what is the hint? how to use it to reduce the query processing in program?..

Answer / usha

Hints is nothing but clues.
By using hints we can improve the query performence.

Is This Answer Correct ?    2 Yes 2 No

what is the hint? how to use it to reduce the query processing in program?..

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

Post New Answer

More Informatica Interview Questions

what is confirmed dimension?

6 Answers  

Clarify the utilization of aggregator cache record?

0 Answers  

What are the new features of Power Center 5.0?

0 Answers  

A session S_MAP1 is in Repository A. While running the session error message has displayed

1 Answers  

tell me 5 session failure in real time how can you solve that in your project?

0 Answers   CSC,

what is size of u r database?

0 Answers  

What are the issues that you have faced while moving your project from the Test Environment to the Production Environment?

1 Answers  

How to recover the standalone session?

2 Answers  

why do u use shortcuts in informatica.?

4 Answers   iFlex,

what is work of PUSH DOWN option

2 Answers   Wipro,

what is incremental loading ?

12 Answers   CTS, IBM, Oracle, TCS,

What are the types of presistent cache in look up tr.

0 Answers   IBM,

For more Informatica Interview Questions Click Here
Categories