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.
Answers were Sorted based on User's Feedback
Answer / sony_infa
use session partition to improve the performance.
| Is This Answer Correct ? | 1 Yes | 0 No |
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 |
Answer / sony_infa
using session partition we can improve the performance.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / subhransu panda
Using session partition we can reduce the time.
Because at a time the parallel pipeline created in session partition will process the incoming data ,by distributing the data in equal nos among the parallel pipelines.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is meant by LDAP users?
write a sql query following table? col1 col2 1 2 1 2 1 2 3 4 3 4 5 6 i want the output like unique duplicate col1 col2 col1 col2 1 2 1 2 3 4 1 2 5 6
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What is the difference between informatica 8.x and 9.x
What is different between informatica version 8 and 9 version
how do u move the code from development to production?
How to differentiate between the active and passive transformations?
scenario
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
what is the purpose of surrogate key and diff between primary key&surrogate key
During the running session, output files are created by informatica server. Enlist few of them.
any body can say about all versions of informatica ?how many versions ?