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

Whats there in global repository

0 Answers  

How do you implement unconn. Stored proc. In a mapping?

1 Answers  

What is the internal processes of integration server in Informatica? How data will be extract and load to the target?

0 Answers   TCS,

What is hash partition?

2 Answers  

Diffrence between static and dynamic cache

2 Answers   HCL,

difference between informatica 8.1.1 and 8.6

0 Answers   TCS,

What is partioning?how many types of partinings are there

2 Answers   HCL,

How to load a Dimension ? and how to load a fact table?

0 Answers  

what is size of u r database?

0 Answers  

on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records

4 Answers   Fidelity,

Can we use unconnected lookup as dynamic lookup?

5 Answers   ITC Infotech, TCS, Wipro,

How will you display "Mr" for male & "Mrs" for female in target table?

7 Answers  

For more Informatica Interview Questions Click Here
Categories