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 / venkateshmalneni
if we do the performance optimization we can achieve the task i think (ie we can reduce the time of loading the data into target)
if my answer is wrong please let me know the write answer
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is standalone command task?
explan ur project architecture?
How can informatica be used for an organization?
Make a note of the quantity vaults made in informatica?
Differentiate between reusable transformation and mapplet.
What are the differences between joiner transformation and source qualifier transformation?
Define mapping and session?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Partition, what happens if the specified key range is shorter and longer
What is InformaticaPowerCenter?
Differentiate between source qualifier and filter transformation?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What is aggregate cache in aggregator transformation?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Can we change Dynamic to Static or Persistent cache? If so what happens?