What is the difference between partitioning with key and
round robin?
- 7 Answers
- 24261 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 |
how can you convert 3 way to 7way partitioning in abinitio?
Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data?
What is a partition?
In abinitio, what types of parallelism are used?
How you can delete an object from EME data store ? How to use in abinitio graph?
Have you used rollup component? Describe how.
What would be the next step after collecting the data?
We know rollup component in abinitio is used to summarize group of data record then why do we use aggregation?
Why is data processing considered beneficial?
Can you read multiple input files using one input file component ? (Same DML) How to use in abinitio graph?
What is the difference between rollup and scan?
What is the best way of creating huge test feeds?
Teradata 
