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

What is the difference between a connected look up and unconnected lookup?

564


What is decode in informatica?

646


What is an expression transformation?

584


Which transformation should we use to normalise the COBOL and relational sources?

736


What is expression transformation?

622






i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

1661


Do you find any difficulty while working with flat files as source and target?

662


Explain dynamic target flat file name generation in informatica

639


Explain how to import oracle sequence into informatica?

582


What is meant by lookup transformation? Explain the types of lookup transformation?

558


What are the differences between oltp and olap?

542


Define pmcmd command?

615


How many ways a relational source definition can be updated and what are they?

573


What is the maplet?

612


What is the function of look up transformation?

642