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
What are the six data process products of ab initio (architecture of ab initio)?
Mention what is rollup component?
List out the file extensions used in abinitio?
What is the syntax for m_dump in abinitio?
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?
Can you explain data flow graph with an example?
What is a deadlock and how it occurs?
Explain what is de-partition in abinitio?
Can sorting and storing be done through single software or you need different for these approaches?
What is data mapping and data modelling?
Explain how abinitio eme is segregated?
What are the different types of parallelism in ab initio?
what is the project environment(for each project the environment is same or different to different project)?
What are the Types of parallelism in detail?
Describe the elements you would review to ensure multiple scheduled batch jobs do not collide with each other?