What is hash partition?

Answer Posted / bhanu pratap

Hash partitioning:-
use hash partitioning , when we want the power center server
to distribute rows to the partitions by groups.

Eg :- we need to sort items by item ID , but we don't know
how many many items have a particular ID mamber

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Tell me about Propagate functions in informatica

524


hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

1647


define galaxy repository in informatica

1729


Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

782


What does refresh system mean, and what are its distinctive choice?

567






What is event and what are the tasks related to it?

616


Enterprise data warehouse your projects phase by phase explain?

1467


Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

786


Explain sessions. Explain how batches are used to combine executions?

597


how tokens will generate?

1738


What are mapplets?

826


Can we create a node as a gateway node and the same node can be assigned to a grid?

638


suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

6089


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1502


How to differentiate between the active and passive transformations?

627