|
What is partitioning and what are some types of partitioning? - ETL
ETL (extract, transform, and load) Testing Interview Questions
(Continued from previous question...)
53.
What is partitioning and what are some types of partitioning? - ETL
Partitioning is when an area of data storage is sub-divided to improve performance. Think of it as an organizational tool. If all your collected data is in one large space without organization the digital tools used for analyzing it will have a more difficult time finding the information in order to analyze it. Partitioning your warehouse will create an organizational structure that will make locating and analyzing easier and faster.
Two types of partitioning are round-robin partitioning and Hash Partitioning. Round-robin partitioning is when the data is evenly distributed among all partitions. This means that the number of rows in each partition is relatively the same. Hash partitioning is when the server applies a hash function in order to create partition keys to group data.
(Continued on next question...)
Other Interview Questions
| 