if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.
Answer Posted / sony_infa
using session partition we can improve the performance.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Suppose we do not group by on any ports of the aggregator what will be the output?
What are the types of lookup transformation?
What are roles and groups and benefits of using them?
What is a code page?
what is size of u r database?
Design a mapping to load the cumulative sum of salaries of employees into target table?
How to load a Dimension ? and how to load a fact table?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
generate date / time dimension in informatica
Explain dynamic target flat file name generation in informatica
What is source qualifier transformation in informatica?