Answer / ash

By Default the intergration service updates the target
based on key columns. But we might want to update non-key
columns also,at that point of time we can override the
UPDATE statement for each target in the mapping.The target
override affects only when the source rows are marked as
update by an update strategy in the mapping.

Answer / usha

target update override which is used to update the data
with out using UPDATE transformation....

if there is no PK in the target we can update by using
target update override

Can we write to_date(three arguments) ? Will it work ? Advance thanks

1 Answers   Puma,

---

What is data merging, data cleansing and sampling?

6 Answers   Satyam,

---

Can any body tell about the (UTC) unit test cases with the examples in informatica.

4 Answers  

---

how can we load starting with 11th record of a table from source to target

6 Answers   IBM,

---

Explain what transformation and how many are there in informatica?

0 Answers  

---

Describe two levels in which update strategy transformation sets?

1 Answers  

---

Hi, This is Lakshmi,Anyone taking classes for datawarehouse-Informatica and BO with real time project

2 Answers  

---

how to get the first row without using rank t/r?

7 Answers   iGate,

---

Differentiate between mapping parameter and mapping variable?

1 Answers  

---

What is domain in terms of informatica?

0 Answers  

---

when informatica 8 series released ?

1 Answers   IBM,

---

HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?

7 Answers   Patni, Wipro,

---