What is the difference between partitioning with key and
round robin?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What will be the output when a file with 0 records is connected as input to a reformat and an output file? Note that in reformat we have assigned hardcoded values to output columns.

517


What is local and formal parameter?

772


What are the types of data processing you are familiar with?

703


Explain how abinitio eme is segregated?

945


How do you add default rules in the transformer?

655






Whenever we load data into oracle table from staging table using exchange partition...then I read somewhere that data actually doesn't move in this and this command only reset the pointer in the data dictionary...so if data doesn't move then how data is loaded into the main table ? I mean wat is the point of pointer update in data dictionary?

566


Describe the process steps you would perform when defragmenting a data table. Does this table contain mission-critical data?

563


Where $mpjret is used in ab-initio?

680


How you can run a graph infinitely in ab initio?

785


Explain data flow graph with an example?

634


explain checkin and checkout?

667


How to compare two dmls in abinitio

1198


Input Data: AAABBBCC CCAAABB expected output A3B3C2 A3B2C2 How can I achieve this in Ab initio? where In output count of occurrences should be sorted from high to low

862


What are the facts that can compromise data integrity?

629


What are the benefits of data analyzing?

674