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
can u any challenge your project?
Did u used latest transformations of 8.6.0? for what?
Define update strategy?
What is workflow manager?
How do you take back up of repository?
Define sessions in informatica etl?
How to update or delete the rows in a target, which do not have key fields?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How to do unit testing in informatica?
What are the informatica performance improvement tips
What are the transformations that are not supported in mapplet?
Differences between version 7.x and 8.x.
What do you mean incremental aggregation?
Explain the informatica workflow?
have u done any performance tuning? how u ll do?