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
use session partition to improve the performance.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is workflow manager?
What is lookup change?
How would you join a node to the already existing domain?
Explain constraint based loading in informatica
Under what condition selecting sorted input in aggregator may fail the session?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What is the need of etl tools?
What are the different lookup cache(s)?
Enlist the tasks for which source qualifier transformation is used.
Explain lookup transformation is active in informatica
What is main use of mapplet?
what is informatica metadata?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
How would you copy the content of one repository to another repository?
What is a sorter transformation?