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
- 3835 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
How can we store previous session logs?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What happens when a session fails and you click on recover?
How to open an older version of an object in the workspace?
How many ways are there to do 'remove duplicate records in informatica'?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
How to do the error handling of if ur source is flatfiles?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
what are the Methods For Creating Reusable Transformations?
What is meant by target load plan?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Design a mapping to load a target table with the following values from the above source?
As union transformation gives UNION ALL output, how you will get the UNION output?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
