What is hash partition?



What is hash partition?..

Answer / 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

More Informatica Interview Questions

How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.

9 Answers   Barclays,


How to update records in Target, without using Update Strategy?

3 Answers  


what is hash table in informatica?

1 Answers   Zensar,


how may sources can be used in a mapping at a time?(limit)

6 Answers   IBM,


How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?

4 Answers   IBM,






IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

0 Answers  


Explain about HLD and LLD ?

16 Answers   Accenture,


Reusable transformation and shortcut differences

0 Answers  


What is Index Caches size?

0 Answers   Informatica,


How to configure mapping in informatica?

0 Answers  


What is IQD file?

1 Answers  


How to load the data from people soft hrm to people soft erm using informatica?

0 Answers  


Categories