What is hash partition?

Answer Posted / sudhanshu

Hash Partitioning, which maps data to partitions based on a
hash function. The physical location of the data depends on
the outcome of hash function. Data used to distributed
between the partitions. This is typically used where ranges
are not appropriate

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we use mapping variables in informatica? Where do we use them?

616


What are the modules in Power Center

1228


What is a pre-defined event and user-defined event?

577


What is an expression transformation?

586


How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1004






What is the format of informatica objects in a repository?

596


What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

7669


When do you use sql override in a lookup transformation?

582


where to store informatica rejected data?

674


What are the restrictions of union transformation?

574


What is the function of aggregator transformation?

573


What is the difference between router and filter?

645


What are roles and groups and benefits of using them?

569


Briefly define a session task?

588


What are the new features of Power Center 5.0?

1230