Answer / pooja

In hash partitioning, the Informatica Server uses a hash function to group rows of data among partitions. The Informatica Server groups the data based on a partition key. Use hash partitioning when you want the Informatica Server to distribute rows to the partitions by group

What is joiner change?

0 Answers  

---

what are the reusable tasks in informatica ?

11 Answers   CTS, HP, IBM, TCS,

---

Define pmcmd command?

0 Answers  

---

How do you join more than 3 flat files in informatica?

1 Answers   ITC Infotech,

---

Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

1 Answers   IBM,

---

How do you take care of security using a repository manager

2 Answers  

---

Why sorter is an active transformation?

0 Answers   Informatica,

---

How can one know that a table has indexes and is partitioned? How data will be pulled from Partitions in Oracle for Informatica?

1 Answers  

---

After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?

2 Answers  

---

wt is the difference between truncate and delete in which situation u use delete and truncate in real time..

4 Answers   TCS,

---

We can achieve better perfomance using sorter before an aggragator. Then what is the significance of 'Sorted Input' check in aggregator ?? Please let me know the difference ??

2 Answers  

---

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

0 Answers   Puma,

---