What is partitioning? Explain about Round-Robin, Hash partitioning. - ETL

What is partitioning? Explain about Round-Robin, Hash partitioning.

- Partitioning is to sub divide the transactions to improve performance.

- Increasing the number of partitions enables Informatica Server for creation of multiple connections to various sources.

- The following are the partitions

Round-Robin Partitioning:

- Data is distributed evenly by Informatica among all partitions.

- This partitioning is used where the number of rows to process in each partition are approximately same

Hash Portioning:

- Informatica server applies a hash function for the purpose of partitioning keys to group data among partitions.

- It is used where ensuring the processes groups of rows with the same partitioning key in the same partition, need to be ensured.