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

we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks

3 Answers   TCS,

---

what is the size of ur database(like oracle)

2 Answers   HP,

---

what is upstream and downstream transformation?

7 Answers  

---

After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?

3 Answers   TCS,

---

What are the tasks that Loadmanger process will do?

1 Answers  

---

---

What are the types of maping wizards that r to be provided in Informatica?

2 Answers  

---

How can you access the remote source into your session?

1 Answers  

---

Can we create multiple integration service on single repository?

0 Answers  

---

What is staging area?

11 Answers  

---

Explain joiner transformation in informatica

0 Answers   Informatica,

---

Differences between version 7.x and 8.x.

0 Answers   Accenture, Cognizant,

---

hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.

5 Answers   TCS,

---