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

Differentiate between a repository server and a powerhouse?

0 Answers  

---

What is Performance tuning in Informatica?

1 Answers   CTS, GE, TCS,

---

what are testing in a mapping level please give brif eplanation

1 Answers   CTS,

---

what is the look up transformation?

2 Answers   Informatica,

---

What is confirmed dimension?

3 Answers  

---

a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100

2 Answers   Cap Gemini,

---

What is the difference between bitmap and btree index?

2 Answers   CTS, TCS,

---

If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?

2 Answers   IBM, WalMart,

---

 Informatica Checkpoints

0 Answers   DELL,

---

How to do the error handling of if ur source is flatfiles?

0 Answers  

---

my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same

2 Answers   KPIT,

---

When the informatica server marks that a batch is failed?

2 Answers  

---