Home > Software > Data-Warehouse > Informatica
Interview Questions   Tutorials   Discussions   Programs   

Informatica - How the informatica server increases the session performance through partitioning the source?




449
views
asked marvit September 20, 2014 08:02 AM  

How the informatica server increases the session performance through partitioning the source?


           

1 Answers



 
answered By vishnoiprem   0  
For a relational sources informatica server creates multiple connections for each partition of a single source and extracts separate range of data for each connection.Informatica server reads multiple partitions of a single source concurrently.Similarly for loading also informatica server creates multiple connections to the target and loads partitions of data concurrently.
For XML and file sources,informatica server reads multiple files concurrently.For loading the data informatica server creates a separate file for each partition(of a source file).U can choose to merge the targets.
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert