What is the difference between partitioning with key and
round robin?
- 7 Answers
- 25657 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 |
Describe what the SQL Server tempdb and tlog files are used for?
Why creation of temporary files depends on the value of MAX CORE
What are the six data process products of ab initio (architecture of ab initio)?
What is meant header and tailer, suppose header and tailer had some junk data how will delete junk data ? which components r used?
Can we specify checkpoints without Phases?
What are the facts that can compromise data integrity?
What are the benefits of data processing according to you?
what is the relation between EME , GDE and Co-operating system ?
what is the use of stdenv in abinitio and what the main concept belongs to is?what is env?
what is the difference between .dbc and .cfg file?
what is difference between fuse and join? Explain in detail? In which scenario we will use them?
How do you add default rules in the transformer?
Teradata 
