Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between partitioning with key and
round robin?
- 7 Answers
- 27622 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 latest version that is available in Ab-initio?
Explain what does dependency analysis mean in abinitio?
What is the significance of record required indicator of Join component ? How to use in abinitio graph?
What is a cursor? Within a cursor, how would you update fields on the row just fetched?
11. What is the use of allocate()?
What is the difference between a scan component and a rollup component?
Have you ever encountered an error called “depth not equal”?
)what is wrapper script?where it is going to execute and why we go for wrapper?
How many components in your most complicated graph?
What is conditional DML and Structured DML?
what is difference between chk point n phase.Say im loading a file (containig 1 lakh records) and my graph fails after loading 50,000th record.What is the advantage of using check point in this case. Will i be able to start from 51000th record.
Describe the process steps you would perform when defragmenting a data table. Does this table contain mission-critical data?
Teradata 
