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

Why update strategy and union transformations are active? Explain with examples.

816


Explian the Process of deployment groups in informatica

730


Explain the features of connected and unconnected lookup.

639


What is confirmed fact in dataware housing?

5914


Briefly define a session task?

678






Explain the tuning lookup transformation - informatica

693


What are the basic requirements to join two sources in a source qualifier transformation using default join?

697


What are the validations that you can perform in oracle and in informatica ? Advance Thanks

1737


can u any challenge your project?

1696


What is informatica powercenter repository?

814


can u give example for factless fact table

5737


What is meant by LDAP users?

776


How many number of sessions can one group in batches?

798


What is the need of etl tools?

715


What is an unconnected transformation?

764