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 |
How to load the source table into flat file target(with columns) in informatica?
What is the difference between a connected look up and unconnected lookup?
what is materialized view?
What are the types of metadata that stores in repository?
Explain lookup transformation source types in informatica
following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?
What is the Difference between DSS & OLTP?
can we use bulk loading when we use look in mapping
If I am having 6 flat files in data. How can you load the data at a time
How do you promote a non-reusable transformation to reusable transformation?
What is the difference between lookup override and souce qualifier override ?
Write the unconnected lookup syntax and how to return more than one column.