Tell me one complex query in oracle ?

2 Answers   L&T, Satyam,

---

how can u tune u r informatica mapppings

2 Answers   CTS,

---

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

0 Answers   CTS,

---

what is surrogatekey ? In ur project in which situation u has used ? explain with example ?

6 Answers  

---

How can we update a record in the target table without using update strategy?

0 Answers  

---

How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)

3 Answers   Atriax,

---

why we use materialized view over view?

1 Answers   Zensar,

---

How can we improve session performance in aggregator transformation?

0 Answers   Informatica,

---

How to compare Source and Target table, without using dynamic lookup?

4 Answers  

---

Can we make worklet inside worklet?

1 Answers  

---

how the informatica server sorts the strings values in rank transformations?

3 Answers   TCS,

---

What is the difference between SOURCE and TARGET BASED COMMITS?

3 Answers   IBM,

---