What is hash partition?

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


Please Help Members By Posting Answers For Below Questions

After the generation of a report to whom we have to deploy or what we do after the completion of a report?

512


what are the major three types of modeling used?

624


Why is dimensional normalization not required?

629


What are the data types present in bo?

574


what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.

1820






What are the methodologies of data warehousing?

574


Explain what type of indexing mechanism do we need to use for a typical datawarehouse?

609


What is an er diagram?

638


Can any one explain about core dimension, balanced dimension, and dirty dimension?

641


What is static and local variable?

563


Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar

1561


How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.

539


What is data validation strategies for data mart v?

556


What is prompt types of prompts?use of prompts syntax of prompt?

669


What are the mapping paramaters and maping variables?

571