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

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

0 Answers   CTS,

every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.

1 Answers   IBM,

Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?

2 Answers  

what is a transforamation?

5 Answers  

I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI If a new record coming from source from same location it should directly go to specified location in target at begining EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent

5 Answers   Polaris, Zensar,

how to load only the first and last record of a flat file into the target?

8 Answers   CTS,

how to delete duplicate records by using filter transfermation?

3 Answers  

How would you join a node to the already existing domain?

0 Answers  

what is SDLC way of code development?

0 Answers  

what is the architecture of any Data warehousing project?

5 Answers   IBM,

What is the advantage of persistent cache? When it should be used.

1 Answers   Wipro,

what is the flow?

1 Answers  

For more Informatica Interview Questions Click Here
Categories