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 |
What is router transformation
When you move from devel to prod how will you retain a variable
Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj
Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?
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?
what is mapping optimization? wat are the techniques for tat
what is metadata?
How will you combine 3 different sources with a single source?
What is workflow monitor?
how to load only the first and last record of a flat file into the target?
what is constraint based load order
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment?