Answer Posted / kish

Hi Krishna,

i think you r wrong...he is asking abt flat file...
by using LOOKUP we can eliminate duplicates...
You can eliminate duplicates and can capture that duplicates
using
dynamic lookup cache. look up the target table if New lookup
row=0 then it is unchanged (duplicate
record) SEND TO ONE TARGET

What is data movement mode in Informatica and difference between them?

1138

---

What is meant by lookup transformation? Explain the types of lookup transformation?

952

---

What are connected or unconnected transformations?

1123

---

What are Dimensional table?

1058

---

What is target load order?

1248

---

What is flashback table ? Advance thanks

1942

---

What is aggregator transformation in informatica?

952

---

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1283

---

What are the different types of transformation available in informatica.

1105

---

What is status code in informatica?

1022

---

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5676

---

Where do we use mapping variables in informatica?

1066

---

What can we do to improve the performance of informatica aggregator transformation?

1095

---

what is size of u r database?

2311

---

What is a standalone command task?

1206

---