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


Please Help Members By Posting Answers For Below Questions

What is meant by pre and post session shell command?

617


What is joiner change?

668


Why update strategy and union transformations are active? Explain with examples.

701


Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

624


What is flashback table ? Advance thanks

1476






How to create or import flat file definition in to the warehouse designer?

609


Write the program through which the records can be updated?

507


What are the different types of repositories created using informatica?

651


What is a node in Informatica?

617


What are the basic requirements to join two sources in a source qualifier transformation using default join?

609


What are mapplets?

812


How to do unit testing in informatica? How to load data in informatica ?

642


Separate from a database, an information bazaar, and an information stockroom?

602


Why union transformation is an active transformation?

651


Under which circumstances, informatica server creates reject files?

589