Explain the types of transformations?

0 Answers  

---

In session log thier should not be a single error how will u do

3 Answers   HCL,

---

Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?

2 Answers  

---

what is distinct

4 Answers  

---

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

6 Answers   iFlex, Morgan Stanley,

---

Load data to multiple targets according date. When First time session runs it should send to 1st target,second time session runs then send to 2nd target and goes on how to achieve it

1 Answers  

---

"Change cache" in Informatica ?

2 Answers  

---

When do you use sql override in a lookup transformation?

0 Answers  

---

Enlist the advantages of informatica.

0 Answers  

---

What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?

5 Answers  

---

is it possible to index the data in cache of lkp transformation ?

0 Answers  

---

Using Connected or unconnected lookup for performance wise which one is preferable?.

1 Answers   Deloitte,

---