How to load query faster,so that It will take less time to load?
- 1 Answers
- 3163 Views
- BNP Paribas, I also Faced
- E-Mail Answers
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 the status code in stored procedure transformation?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
What is workflow monitor?
What is meant by lookup transformation? Explain the types of lookup transformation?
What is a rank transform?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Mention a few design and development best practices for informatica?
What are the prerequisite tasks to achieve the session partition?
what is the complex transformation you used in informatica
Which is the t/r that builts only single cache memory?
Plz can any one say me how to get the informatica certification materials and dumps
What are mapplets? How is it different from a Reusable Transformation?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
How are indexes created after completing the load process?
