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
Explain joiner transformation in informatica
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
How can you define user defied event?
Differences between connected and unconnected lookup?
How can we handle two sessions in informatica?
How is union transformation utilized?
Whats there in global repository
What are the types of caches in lookup? Explain them.
Which transformation should we use to normalise the COBOL and relational sources?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is a passive transformation?
How do you use reject loader.
How do you handle two sessions in Informatica
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is Cognos script editor?