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
How do you use reject loader.
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Differentiate between source qualifier and filter transformation?
Design a mapping to load a target table with the following values from the above source?
Explain what is informatica metadata and where is it stored?
What does update strategy mean, and what are the different option of it?
can we override a native sql query within informatica? Where do we do it?
What are the advantages of informatica?
tell me 5 session failure in real time how can you solve that in your project?
Briefly define reusable transformation?
How can you validate all mappings in the repository simultaneously?
How are indexes created after completing the load process?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What are active and passive transformations?
What is meant by pre and post session shell command?