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 |
Describe data concatenation?
my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000 4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement is like this id name sal up_sal,1 aa 1000 null,2 bb 2000 1000, 3 cc 3000 2000 4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on so how can i get it plez reply for this as soon as possible , thanks in advanced
How can we get two output ports in un-connect transformation?
When do you use sql override in a lookup transformation?
write a query for how to eliminate the duplicate rows without using distinct?
Explain the different lookup methods used in informatica?
Types of error logs in Informatica?
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
What are the static cache and dynamic cache in informatica?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Explain the different dimensions.
Why we use lookup transformations?