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


how do u tune queries?



how do u tune queries?..

Answer / chitti

U CAN TUNE U R QUERIES BY CREATING INDEXES ON COLUMNS,AND
ELIMINATING KEY CONSTRAINTS .AND ALSO GIVE SORTING IN SQL
ITSELF.

Is This Answer Correct ?    2 Yes 4 No

Post New Answer

More Informatica Interview Questions

What is the term PIPELINE in informatica ?

7 Answers   Deloitte,


In target table how to display the system time

1 Answers  


Hi All can anyone tell me where i will get Informatica training in Mumbai?

3 Answers  


If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks

7 Answers   Puma,


If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?

1 Answers   Amdocs,


server hot-ws270 is connect to Repository B. What does it mean?

0 Answers   Cognizant,


What is a stored procedure transformation?

0 Answers  


HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.

8 Answers   CTS,


Diffrence between static and dynamic cache

2 Answers   HCL,


scenario where i can use only concurrent execution of workflow.

0 Answers   Cognizant,


supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How

4 Answers   TCS, Wipro,


What are the different types of repositories created using informatica?

0 Answers  


Categories