Thursday 7 January 2016

Explain what is partitioning, hash partitioning and round robin partitioning?

To improve performance, transactions are sub divided, this is called as Partitioning. Partioning enables Informatica Server for creationg of multiple connection to various sources
 The types of partitions are
 Round-Robin Partitioning:
 By informatica data is distributed evenly among all partitions
 In each partition where the number of rows to process are approximately same this partioning is applicable
 Hash Partitioning:
 For the purpose of partitioning keys to group data among partitions Informatica server applies a hash function
 It is used when ensuring the processes groups of rows with the same partitioning key in the same partition need to be ensured

No comments:

Post a Comment