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
What are the various types of layout supported by abinitio?
Mention what information does a .dbc file extension provides to connect to the database?
State the relation between EME, GDE and Co-operating system?
We know rollup component in abinitio is used to summarize group of data record then why do we use aggregation?
what is the use of catlog or catlogfile?
What happens when we provide null key to sort, merge and pbks in Abinitio ?
Have you used rollup component? Describe how.
How data is processed and what are the fundamentals of this approach?
Describe what the SQL Server tempdb and tlog files are used for?
What are the components new in 2.14 compared to 1.8 and State the usage of the components?
Explain the methods to improve performance of a graph?
How abinitio eme is segregated?
what is the difference between usersandbox,privatesandbox,publicsandbox,commonproject sandbox?
What are the co> operating system’s assorted library of integrated components?
Why might the optimizer use a table scan when an index is available?