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 |
How to load time dimension?
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?
What are the disadvantages of Sequence Generator T/R?
What is the meaning of decode in informatica?
Where should yoU place the flat file to import the flat file defintion to the designer?
How to eliminate duplicates in FF and oracle both
What is standalone command task?
my source is junk data how will u remove that junk data by using unix please any one replay me
What are the transformations that are not supported in mapplet?
WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT , UPDATE OPRATION ?
Hi,tell me the system testing and Integration Testing in the Informatica ? Thank You
From where we can start or use pmcmd?