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 / 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 |
Post New Answer View All Answers
When do you use sql override in a lookup transformation?
Reusable transformation and shortcut differences
How do you load unique records into one target table and duplicate records into a different target table?
Explain the types of lookup transformation?
Can you generate sequence numbers without using the sequence generator transformation?
Design a mapping to load a target table with the following values from the above source?
How to call shell scripts from informatica?
What is persistent lookup cache?
What can we do to improve the performance of informatica aggregator transformation?
Please let me know how to make Data masking in informatica..
Where is metadata stored?
Explain informatica architecture - version 8 / 9
How to update source definition?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
How can we handle two sessions in informatica?