Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 5 Answers
- 9667 Views
- Wipro, I also Faced
- E-Mail Answers
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 how many types of dimensions are available in informatica?
What is informatica? Why do we need it?
What is exclusive and normal mode for repository services?
Explain what are the different types of transformation available in informatica.
What is option by which we can run all the sessions in a batch simultaneously?
How do you load first and last records into target table?
What do you understand by term role-playing dimension?
How can we store previous session logs?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
How to improve the performance of a session using sorter transformation?
What do you mean incremental aggregation?
What are the limitations of joiner transformation?
What is a standalone command task?
How would you join a node to the already existing domain?
