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
What is meant by pre and post session shell command?
What is joiner change?
Why update strategy and union transformations are active? Explain with examples.
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is flashback table ? Advance thanks
How to create or import flat file definition in to the warehouse designer?
Write the program through which the records can be updated?
What are the different types of repositories created using informatica?
What is a node in Informatica?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What are mapplets?
How to do unit testing in informatica? How to load data in informatica ?
Separate from a database, an information bazaar, and an information stockroom?
Why union transformation is an active transformation?
Under which circumstances, informatica server creates reject files?