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  

---

What are connected or unconnected transformations?

0 Answers   Informatica,

---

without dynamic lookup how to insert new rows and update existing rows?

1 Answers   HP,

---

I still need further explanation about the difference between active and passive transformation with some examples.Thank You

5 Answers  

---

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?

0 Answers   IBM,

---

---

.prm wirh repalce .txt is possible?

2 Answers  

---

In Which scenario did u used Incremental loading?

2 Answers  

---

i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?

9 Answers   Cap Gemini,

---

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 version control in informatica ? Advance thanks

6 Answers   HCL, Puma,

---

In Flat file Input is A B C I need output like this A A A B B B C C C. How will u achieve this?

5 Answers   iNautix,

---

when we create source as oracle and target as flat file, how can i specify first row as column in flat file?

1 Answers  

---