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

Which tool yoU use to create and manage sessions and batches and to monitor and stop the informaticaserver?

4 Answers  

---

What are the types of data warehouses?

0 Answers   Informatica,

---

what is shortcut in informatica? difference between shortcut,reusable object?

2 Answers   Virtusa,

---

What is a snowflake schema?

0 Answers  

---

Performance tuning( what you did in performance tuning)

0 Answers   Infosys,

---

---

Comment on significance of oracle 9i in informatica when compared to oracle 8 or 8i?

1 Answers  

---

What are the different transaction levels available in transaction control transformation?

0 Answers   Informatica,

---

what are cost based and rule based approaches and what is the difference?

1 Answers  

---

In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1 Answers   HP,

---

1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?

2 Answers   Accenture,

---

Can anyone tell me the new features in Informatica 9 Version?

2 Answers   Syntel,

---

What are the designer tools for creating transformations?

0 Answers   Informatica,

---