How to load query faster,so that It will take less time to load?
- 1 Answers
- 3162 Views
- BNP Paribas, I also Faced
- E-Mail Answers
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 do you take back up of repository?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?
What is a test load?
Q. Informatica workflow, it is running beyond two hours for last couple of runs, normally it completed less then 30 min., hardly 40 min, last couple of run crossing 2 hours and more in that workflow only one session. now it is aasign to you that how to idenitfy the performance issue of the sesion of production.
What is the meaning of up gradation of repository?
Can any one explain or sujjest some sites for scd mappings.Thank you
What is the main data object present inbetween source and target. I answered Mapping. Transformation etc.. But it is not the answer. So please give me an apt answer. Thanks in advance
following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?
How to Join Tables my Source is having 15 table target is one?
How can we join the tables if they don't have primary and foreign key relationship and no matching port?
How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?
Teradata 
