What are the types of parallelism?
-
pipeline parallelism
-
partition parallelism
-
All the above
-
None of the above
C
Correct answer
Explanation
The two main types of parallelism in ETL processing are pipeline parallelism (breaking data flow into concurrent stages where output from one stage flows to the next) and partition parallelism (splitting data into subsets processed simultaneously on different processors). Pipeline parallelism improves throughput by overlapping different operations like extraction, transformation, and loading. Partition parallelism reduces processing time by handling multiple data partitions concurrently.