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



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

How to load time dimension?

1 Answers   Ford,


Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

0 Answers  


What are the disadvantages of Sequence Generator T/R?

3 Answers   Zensar,


What is the meaning of decode in informatica?

0 Answers  


Where should yoU place the flat file to import the flat file defintion to the designer?

4 Answers  






How to eliminate duplicates in FF and oracle both

3 Answers   CSC,


What is standalone command task?

0 Answers  


my source is junk data how will u remove that junk data by using unix please any one replay me

0 Answers   Cap Gemini,


What are the transformations that are not supported in mapplet?

0 Answers  


WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT , UPDATE OPRATION ?

4 Answers   Oracle,


Hi,tell me the system testing and Integration Testing in the Informatica ? Thank You

2 Answers   TCS,


From where we can start or use pmcmd?

3 Answers  


Categories