Interested to Buy Any Domain ? << Click Here >> for more details...
How to load query faster,so that It will take less time to load?
- 1 Answers
- 3672 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
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
How do you load alternate records into different tables through mapping flow?
What is the use of code page?
lookup transformation with screenshots
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Explain dynamic target flat file name generation in informatica
What are Dimensional table?
How can we improve session performance in aggregator transformation?
Differentiate between source qualifier and filter transformation?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
what is the difference between informatica6.1 and infomatica7.1
Explain the shared cache and re-cache?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
How do you change a non-reusable transformation to reusable transformation?
Explain the scenario which compels informatica server to reject files?
