Interested to Buy Any Domain ? << Click Here >> for more details...
What is hash partition?
- 2 Answers
- 8391 Views
- I also Faced
- E-Mail Answers
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 |
Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400
How we can get unique records into one target table and duplicate records into another target table??
11 Answers Deloitte, IBM, iGate,
Partition, what happens if the specified key range is shorter and longer
how do the project develops? pls specify right from the start to end in step by steps.
i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me
What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.
Can I create one wrkflw which will run different wrkflws on schedule time?
How to load a relational source into file taget?
What is sorter transformation?
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.
Explain factlessfact table with scenario
What is the commit type if you have a transaction control transformation in the mapping?
Teradata 
