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...

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

Answer Posted / usha

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

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2148


explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2166


Can we get 1st record through Informatica(without sequence number).

1483


-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5800


How to load the name of the current processing flat file along with the data into the target using informatica mapping?

1279


Explain sessions?

1073


Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1105


What is parallel processing in informatica?

1718


Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

2032


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

6498


What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

978


Why union transformation is an active transformation?

1050


How many dimensions are there in informatica?

1096


Why do you use Mapping Parameter and mapping variable?

1772


What is sorter transformation?

1054