Google News
logo
ETL Testing - Interview Questions
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 creating 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
Advertisement