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

How to load query faster,so that It will take less time to load?

Question Posted / shiva55


How to load query faster,so that It will take less time to load?..

Answer / karthik

You can increase the loading of query faster in following ways:

Query Optimization (Reducing the complexity in query).
Buffer cache increasing
Using Tier 0 (Flash storage) to increase IOPS.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation

1 Answers   TCS,

What is the term PIPELINE in informatica ?

7 Answers   Deloitte,

What are the various types of transformation?

0 Answers  

what is normalizer transformation?

4 Answers   Wipro,

WHAT IS FACT TABLES?

2 Answers  

Different circumstance which drives informatica server to expel records?

0 Answers  

I have 1200 records how can u send it in aggregator with good performance issues?

3 Answers  

where to select code page option?

2 Answers   TCS,

In ur current projectu have done any performance tuning of mappings?

1 Answers  

What are the different ways to implement parallel processing in informatica?

0 Answers  

What is Session and Batches?

0 Answers   Informatica,

how do u move the code from development to production?

6 Answers  

For more Informatica Interview Questions Click Here
Categories