What is the difference between partitioning with key and
round robin?
- 7 Answers
- 25053 Views
- TCS, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pradeep
1)Partition by key needs a key where round robin doesnot need
2)Round Robin always tries to distribute the records
equally.where partition by key not.
| Is This Answer Correct ? | 21 Yes | 2 No |
Answer / shashank
Partitioning by key distributes the data into various
multifile partitions depending upon of the fields present in
the input(key), while Partitioning by round robin distribues
data equally among the partitions irrespective of the key
field. Round robin ensures equitable distribution of data
among the partitions, while By key may lead to inequitable
distribution.
| Is This Answer Correct ? | 13 Yes | 0 No |
Answer / guest
in patitioning with key the partitioning is based on key
whereas round robin is not based on key
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / nag
Partition by key distributes the data records accroding to
the specified key.
Partition by round robin distributes blocks of data records
evenly in round and robin fashion
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / supriya
Partition by key distributes the data records accroding to
the specified key.
Partition by round robin distributes blocks of data records
based on block size (parameter) in round robin fashion
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / suresh
partition by key distributes data records to its out put flow partitions according to key values
where as partition by round robin distributes data records to its out put flow partitions based on block size in round robin fashion
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / shiba
- In PBK, partition of data are done according one specific key. But in PBRR, partition is done according the block size.
- In PBK, data flows to the output randomly, but in PBRR, data flows to output in orderly format.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the difference between In-Memory Sort and Inputs must be sorted?
Describe what the SQL Server tempdb and tlog files are used for?
How can you import XML repositories exported from different tools like ODI
Have you worked with packages?
List out the file extensions used in abinitio?
What is the best way of creating huge test feeds ? How to use in abinitio graph?
What are the different String functions used in Abinitio?
from a graph how to select only second record always in scan?
What is the difference between dml expression and xfr expression?
What is data mapping and data modelling?
What will be the output of using partition by Round-Robin after the partiton by key in ab initio?
what is decoding & what is NVL?
Teradata 
