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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the various types of layout supported by abinitio?

673


Mention what information does a .dbc file extension provides to connect to the database?

812


State the relation between EME, GDE and Co-operating system?

771


We know rollup component in abinitio is used to summarize group of data record then why do we use aggregation?

993


what is the use of catlog or catlogfile?

2007






What happens when we provide null key to sort, merge and pbks in Abinitio ?

1025


Have you used rollup component? Describe how.

745


How data is processed and what are the fundamentals of this approach?

743


Describe what the SQL Server tempdb and tlog files are used for?

1914


What are the components new in 2.14 compared to 1.8 and State the usage of the components?

1813


Explain the methods to improve performance of a graph?

752


How abinitio eme is segregated?

915


what is the difference between usersandbox,privatesandbox,publicsandbox,commonproject sandbox?

3511


What are the co> operating system’s assorted library of integrated components?

749


Why might the optimizer use a table scan when an index is available?

1915