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

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.

Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer

0 Answers  

---

What is the Rankindex in Ranktransformation?

7 Answers  

---

How can we get multiple output values using an unconnected lookup transformation?

2 Answers   TCS,

---

what is the necessity to use update strategy?(except for updates)

2 Answers   Emphasis,

---

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

2 Answers   TCS,

---

Can anyone briefly describe abt audit table loading?

2 Answers   TCS,

---

we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?

1 Answers   Polaris,

---

what is the difference between Informatica 7.1 and Abinitio?

1 Answers   TCS,

---

Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why?

6 Answers   iFlex, Morgan Stanley,

---

What is powercenter on grid?

0 Answers  

---

How to do unit testing in informatica? How to load data in informatica ?

0 Answers  

---

any body can say about all versions of informatica ?how many versions ?

2 Answers  

---