What is hash partition?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / murali s
The value of a hash function determines membership in a
partition. Assuming there are four partitions, the hash
function could return a value from 0 to 3.
| Is This Answer Correct ? | 1 Yes | 0 No |
Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .
What are the ETL tools available in DWH?
Do you find any difficulty while working with flat files as source and target?
What is the benefit of session partitioning?
What is the function of aggregator transformation?
how to read data from website into informatica? plsss send answers ASAP thanks in advance.
To provide support for Mainframes source data,which files r used as a COBOL files
What could be the possible resons of locks by user?
If you want to create indexes after the load process which transformation you choose?
What is difference macros and prompts?
what is the difference between onsite & client site?
Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?