Answer Posted / rayudu

Yes By default if we wont use update stratagey t/r it will
insert the record by default .And if we want to update
without using update stratagey give the property UPDATE for
TreatSource rows at session level and in target properties
give updateas Update so that we can update without using UPD
T/r.

Regards,
rayudu.

How do you migrate data from one environment to another?

1095

---

Explain pushdown optimization and types in informatica

1077

---

How do you load only null records into target? Explain through mapping flow.

2016

---

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

1142

---

What are the features of complex mapping?

1154

---

What does reusable transformation mean?

1132

---

What are the modules in Power Center

1678

---

What is sorter transformation?

1043

---

What are different types of transformations available in informatica?

987

---

How many input parameters can exist in an unconnected lookup?

1543

---

Define mapping and session?

1033

---

What is the function of look up transformation?

1123

---

scenario where i can use only concurrent execution of workflow.

3167

---

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2136

---

What is data caches/ index caches?

1099

---