Answer Posted / guest
A hash partition is used to ensure even distribution of
data among pre determined number of partitions. It has to
be called explicitly by addressing column Partition by
Hash.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is Analysis Services?
What is difference between query studio and report studio?
Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?
What is the difference between star and snowflake schemas?
Explain what type of indexing mechanism do we need to use for a typical datawarehouse?
What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?
What is junk dimension? What is the difference between junk dimension and degenerated dimension?
What is the main difference between inmon and kimball philosophies of data warehousing?
Which component has onread method and what it is used for?
what are the major three types of modeling used?
What are the types of partitioning?
Explain what are slowly changing dimensions?
What is metadata in context of a datawarehouse and how it is important?
What is Active Datawarehousing?
Explain the data type of the surrogate key?