How to load query faster,so that It will take less time to load?
Answer Posted / 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 View All Answers
What is an expression transformation in informatica?
What is transformation?
Under what condition selecting sorted input in aggregator may fail the session?
What differs when we choose the sorted input for aggregator transformation?
What all join we can perform in LOOKUP transformation?
Mention few power centre client applications with their basic purpose?
tell me 5 session failure in real time how can you solve that in your project?
Which development components of informatica have the highest usage?
Mention few advantages of router transformation over filter transformation.
How to update or delete the rows in a target, which do not have key fields?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is decode in informatica?
What are the differences between source qualifier and joiner transformation?
what are the deliverables?in your project?
generate date / time dimension in informatica